View Single Post
 
Old 12-15-2016, 07:25 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

When you're setting up the pivot table, just drag Date from the PivotTable fields into the columns box underneath. Once you've done that, you can adjust the grouping by right clicking on any of the column headers in the actual pivot table (Sep, Oct, Nov, etc. here) and selecting "Group...".

To have it group like this, you need to select Year and Month and click OK. Boom! You're done. Let me know if you still have questions.
Reply With Quote