I have two pivot tables that their source is Power Query queries that refer tables on SQL Server databases (Excel 2016).
In one pivot table, I select Pivot Table Options - Data tab, and the choice "Number of items to retain per field" is available. I can change from Automatic to None
In the other pivot table, the same option is grayed and not available.
Do you know why and when this option is unavailable?
Thank you
Nick
In one pivot table, I select Pivot Table Options - Data tab, and the choice "Number of items to retain per field" is available. I can change from Automatic to None
In the other pivot table, the same option is grayed and not available.
Do you know why and when this option is unavailable?
Thank you
Nick