Thread: [Solved] Pivot table date grouping
View Single Post
 
Old 12-03-2013, 05:43 PM
differentdrummer differentdrummer is offline Windows XP Office 2007
Novice
 
Join Date: Nov 2013
Posts: 10
differentdrummer is on a distinguished road
Post 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
Reply With Quote