Forum Discussion
Pivot Table: Date Filters are not Condensed
In this one random excel workbook I am trying to modify, the dates in the pivot table are not condensed. They are all over the place. Usually, when I create a pivot table, the dates are sub-sectioned...
What are your settings here
And why don't to use structured table as the source and not to use data model PivotTable instead of cached PivotTable.
I have to modify the data quite a bit to get the different analysis numbers I need, and look at fiscal month, fiscal quarter, and fiscal year. A Pivot table is just the easiest way I have found to pull the data, see an inconsistency, and imminently go to that data point.
Should I have the last box checked?
Depends on goals, but better to have unchecked
