Forum Discussion
Cannot group that selection in a pivot table
Hi there. I have a formula auto-calculating the next date to a column on which I have a pivot table. I have verified that the dates are valid based on the calendar and that there are no unallowable...
dharbison Not sure if it's acceptable to you but a workaround could be to return 0 in stead of "". That will create a non-sense date 0 January 1900. Use a custom format to display dates, for instance, as
dd/mm/yyyy;;
The two semi-colons at the end force a 0-date to be displayed as a blank. Then, the pivot table will still group dates by year, quarter and month. Filter out the year 1900 and you can create something like this:
