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 ...
As workaround you may use
=IF([@Date]=""; 1; [@Date])With that everything with skipped date will be under Jan 01, 1900
This wouldn't work, because I don't want to see anything in the cells when actual Date is empty. In this case, Date is empty, while Stat would have 01.01.1900.
