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?
2 Replies
Thanks. I didn't create the workbook, so not seeing how the month number switched over to the three character month name. What I did notice is the when I clicked the "Month" dropped down (where I could select specific months to see/not see, all the months were in timeframe order with the exception of Oct and Nov. So it looked like Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Nov, Oct, Dec. Couldn't figure out why that happened or how to fix it. I just added a new column that calculated the three digit month name based off of a date field in the data. It then displayed the information fine.
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?
