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.
I’m the author for this analysis and I see this option for other Pivot tables… I want to enable such options for specifically one pivot table which doesn’t show this option. How can I do that?
I want to be able to export only visible fields CSV for this pivot table.
This option applies to the whole dashboard. You either enable it for all pivot tables or disable it for all. You can’t enable it for some pivot tables only.
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.
Ideally I’d expect the data only until Tier granularity when downloaded - but in CSV we see the data expanded for 3 more columns. Vendor → Lead Local and Studio…