Forum Discussion
PivotTable does not group column with mix of formulas and dates
Hello, I have a table, which has a column with Dates, which I enter manually. And I have a PivotTable using this table as Source. I added column with dates to Rows and Grouped to show Years and ...
Date grouping pivot tables only works when all entries are dates. Empty cells and/or empty strings like "" will block that feature.
Eventually I decided to remove the IF formulas from Stat column, leaving it simply =[@Date] and I copy it from previous line each time, and fill in with another date when I need it to be different. Now Grouping in PivotTable works.
