Forum Discussion
Pivot Table/Slicers Skipping Month
Hello,
I have a Pivot Table where I use data slicers. A couple of the data fields are "Year" and "Month". When I updated the PT with data for October it treats the new data like it is November instead. I reviewed the following:
I verified in the data that there was no incorrect month put in. So there is nowhere in the data where the "Year" = 2025, and the "Month" = "11".
The data that was added to the table has the correct "Year" of 2025, and the correct "Month" of 10.
I verified that the pivot table was set to view all months, which it is (there is data going back to Jan of 2024.).
An additional filter is "Did we answer your question/concern?". This is set to No, and there were three "No's" in October.
If I remove the data for October, then the PT removes the info showing for November.
Including screenshots of the info. Does anyone have any idea why it is doing this?
1 Reply
The "Month" column shows numbers 10, whereas the pivot table has three letter short codes for the month.
Did you just type the numbers 10 or is there a formula behind them? Where do the short codes in the pivot table come from? Did you or someone else perhaps manually over-write them and typed Nov in stead of Oct?
