Pivot Table from Dates to Month
Iím trying to find a way to combine all my dates into just months and show the data for that entire month by month
If I make a pivot table using Name, Dollar amount, and date how I would make the pivot table combine all the dates into months after I move the Dates field under columns and then Ií m not sure what I need to do?
I have attached a spread sheet that I hope helps you understand what I'm trying to do
Thank you for your time and Help