Pivot Table Date Issue
I have a spreadsheet with a data table from which I create a pivot table.
In the columns section of the pivot table, I use the Date field and I want to only show Months.
I am getting a very strange result in the columns (see attached).
Also, when I use the column drop-down in the pivot table, I can see the strange selections as well as all 12 months. The data table ONLY contains data for January 2022.
Tommy
|