![]() |
|
#6
|
|||
|
|||
|
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. |
| Tags |
| sumifs |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with SUMIFS | OTPM | Excel | 8 | 05-27-2016 07:54 AM |
Can I use vlookup to choose what forumula to use in a cell?
|
djrobst | Excel | 17 | 11-03-2015 03:59 AM |
Help with SUMIFS
|
LeFoah | Excel | 2 | 10-20-2013 09:22 AM |
I need help with =SUMIFS
|
docwhit | Excel | 2 | 01-05-2013 12:58 PM |
| need help with a forumula | bigbosky32 | Excel | 1 | 11-07-2008 03:15 PM |