#1
|
|||
|
|||
Pivot table date grouping
I've been fiddling round with this for a while and my guess is that the answer will be "can't be done" but anyhow
Pivot table date grouping allows you to choose from one of more years, quarters,months,days,hours,minutes,seconds. Is there any way (preferably without VBA ) to group by other date/time buckets eg week , 15 minute slots (Sometimes a work-around could be to add the desired bucket to the raw data but not always possible ) Thanks in advance for your help |
#2
|
||||
|
||||
Grouping by week can be done with "Group by days" and set the number of days to 7.
By 15 min slots I don't think so
__________________
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 |
#3
|
|||
|
|||
Thank you
Group by days ... I hadnt ever noticed that you could change the number of days I've just tried it and it will be useful . For the other bucket types I'll stick with adding extra columns to the source data |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Grouping Dates in Excel Pivot Table | mskennedy | Excel | 2 | 02-27-2013 11:09 AM |
Make table cell active add date count date | MelHerndon | Word VBA | 3 | 01-21-2013 04:23 PM |
Pivot Table | uhlersa | Excel | 0 | 10-15-2012 12:01 PM |
Pivot table help | TishyMouse | Excel | 2 | 04-27-2012 10:19 AM |
pivot table | aliasadi_07 | Excel | 1 | 03-11-2012 12:49 AM |