Dec 12 2022 11:24 AM - edited Dec 12 2022 11:25 AM
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?
Dec 13 2022 12:42 PM
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
Dec 13 2022 05:14 PM
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....
Dec 13 2022 05:20 PM