In one of my pivot tables - I do not see options to export only visible fields in Export to CSV. Usually I see 2 options:
1 - All fields
2 - Visible fields only.
In this table, however I can only see 2 options : Export to CSV/ Excel. This doesn’t allow me to download the report exactly in the required format. Can I do something to enable these options for Export to CSV.
Sadly this is not the case. This option is not uniform across pivot tables for me and that is the issue I am facing. I do see Export Visible fields option via CSV for some charts and for some charts there is no option, just the Export via CSV option.
Thank you so much for the explanation.
Adding a field and hiding it gave me the download visible/all fields options. But I guess I’m looking for something else. I’m looking to retain the format of the pivot table that’s visible to me when I expand/ collapse to a certain level.
For instance, to retain this level of info when I download via CSV.
But when I download via CSV: either the all fields option/ visible fields only option I get data down to the least granular level
Thanks for the confirmation@David_Wong! Was wondering if there’s any way to do this in CSV and I had missed it. This is confusing in a way to guide users with multiple limitations on export options but I’ll raise a feature request.