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
|