#1
|
|||
|
|||
Group Date by Quarter in PIVOT TABLE
I have a list of data set. One column has the date which is broken down over a period of one year (i.e - 1/13/2013, 3/4/2013, 5/12/2013, 7/13/2013, 9/12/2013, 11/10/2013 and so on..... Is there a way to group the date by Quarter in my Pivot table. I want the quarter option to show but don't know how to do this. I only see the individual date coming up but want it grouped by quarter. This way I get to group revenue by quarter rather than the individualized date by revenue.
Any help much appreciated. Thanks |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Group Table Rows/Column (like Excel Group) | eoinymc | Word | 1 | 03-11-2014 04:51 AM |
Pivot table date grouping | differentdrummer | Excel | 2 | 12-04-2013 03:07 PM |
Conditional Mail Merge per Student and Quarter | marysilvaramos | Mail Merge | 1 | 01-29-2013 07:17 PM |
Make table cell active add date count date | MelHerndon | Word VBA | 3 | 01-21-2013 04:23 PM |
Pivot table help | TishyMouse | Excel | 2 | 04-27-2012 10:19 AM |