OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Charts and Charting (http://www.officefrustration.com/forumdisplay.php?f=8)
-   -   Pivot Table from Dates to Month (http://www.officefrustration.com/showthread.php?t=1126360)

TylerVL June 16th, 2015 09:27 PM

Pivot Table from Dates to Month
 
1 Attachment(s)
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


All times are GMT +1. The time now is 02:47 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
OfficeFrustration.com