Forum Discussion
Solved
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 inste...
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?
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?