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.
Ok, I removed formulas from empty lines.
Now Source table has:
- a lot of lines that use formula =IF([@Date]="";"";[@Date]) and actually result in a date taken from Date column. None of the formulas result in empty string.
- few lines that have actual date written in them instead of formula
- few empty lines without formulas or anything in them
Grouping is still unavailable in Pivot Table :(
