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:
- Thank you!
-James-Here , you are welcome
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.
