Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-03-2013, 05:43 PM
differentdrummer differentdrummer is offline Pivot table date grouping Windows XP Pivot table date grouping Office 2007
Novice
Pivot table date grouping
 
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table date grouping 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 date grouping pivot table aliasadi_07 Excel 1 03-11-2012 12:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft