Forum Discussion
Pivots with 'Show items with no data' checked now associating wrong months with quarters
Starting today, 12.12.2022, our data pivots that have 'Show items with no data' checked are now associating Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dec with Qtr1 and so on with Q2 - Q4. This never happened before today. Anyone familiar with a change that happened recently or how to fix?
3 Replies
Do you mean months "Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dec" are Qtr1 and other months ("so on") in quarters 2, 3,4 ? Or you mean you had no quarters at all before?
If so you may check in Rows of PivotTable if auto-generated quarter field appears and remove.
In general this setting is responsible for automatic dates grouping
here's a pivot table with 'show items with no data' checked.
now every month is included with every quarter.
wasn't this way last week....
- Yes I know!! I'm trying to Microsoft to admit they made a change that is impacting this. It's fine as long as they give us a way to set a fiscal year and only associate month with those quarters in our fiscal year. We need to be able to show items with no data AND not have every blasted month show aligned with every quarter
