Forum Discussion
Pivot table showing April as Q1
Hi, I have an Excel file with a number of different pivot tables, all split into Year/Quarter/Month. One of those is grouping April in with Q1, instead of Q2 where it should be. I can't see how to...
Waltzingmatilda do you have 'Show items with no data' selected as a field option?
I'm seeing this for the first time ever today as an issue. We have always had the selected so months would appear in the pivot even if there was no data but now it is showing Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and December with Qtr1