Pivot table date column

Copper Contributor

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:




5 Replies


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.



Right click on date and use grouping


@Detlef Lewin 


Thank you for responding & giving me the info. I'll try it out. 

Thank you!

@-James-Here , you are welcome