Pivot table date column

Question

My pivot table has date columns. Each day of the month is a separate column. I want the month total instead in each column.&nbsp;&nbsp;How do I fix it?&nbsp;See screenshot below:&nbsp;&nbsp;

detlef_lewin · Answer

-James-Here&nbsp;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.&nbsp;

sergeibaklan · Answer

-James-Here&nbsp;
Right click on date and use grouping

-james-here · Answer

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

-james-here · Answer

Thank you!

sergeibaklan · Answer

-James-Here&nbsp;, you are welcome

Forum Discussion

Pivot table date column

Share

Resources