View Single Post
  #1  
Old June 16th, 2015, 09:27 PM
TylerVL TylerVL is offline
Member
 
First recorded activity by OfficeFrustration: Jun 2015
Posts: 1
Default 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
Attached Files
File Type: zip Sampledata.zip (26.8 KB, 1665 views)