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:

 

IMG_0033.jpeg

 

5 Replies

@-James-Here 

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.

 

@-James-Here 

Right click on date and use grouping

image.png

@Detlef Lewin 

 

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

Thank you!

@-James-Here , you are welcome