#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 |
#2
|
|||
|
|||
I think you would have to do a calculated column, call it quarter. An easy IF statement based on the date. Then have that one of your row or column headings.
|
#3
|
||||
|
||||
Right click the range with dates in your PT - Selct " Group" - Select quarters ( and the start date) If it does not work, post a sample sheet ( no pics please) (grouping does not work if f.e. the range contains blanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
Group Date by Quarter
Thanks Gebobs (A sample IF Statement will help if you can assist with that - Thanks much!!)
THanks Pecoflyer, I have attached a copy of a sample sheet. I appreciate all help. |
#5
|
|||
|
|||
I'd be interested in how Peco's solution works. I can't seem to figure out how to do it that way.
Anyhoo...attached is the way I did it. |
#6
|
|||
|
|||
Thanks so much Pecoflyer, Got a clearer explanation from other source to figure it out but looking at your solution - I see its what you tried to explain just that I couldn't translate it well.
Simply put - Right click the data in the Date Pivot table column and select range and specify the option of Month, Quarter ...... Thanks Gebobs (U're awesome) that works too. |
#7
|
|||
|
|||
I did that too. Wow...that's great!
|
|
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 |