Forum Discussion
Pivot table date column
My pivot table has date columns. Each day of the month is a separate column. I want the month total instead in each column. How do I fix it? See screenshot below:
First you have to clean your data (#VALUE!, 12:00 time value).
Then refresh the pivot table. Right click on a date, click on Grouping and group by year and month.
