LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default Pivot table date grouping

XL2003. I am analysing data imported from another app. I want to keep the
different dates in the records, but I want to group them into Months in the
pivot table. If there are only a few it lets me, but if there are more than
255 it won't. Can I somehow specify the grouping levels before I drag the
dates onto the field?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
grouping date in pivot table acss New Users to Excel 2 April 17th 09 11:02 PM
Grouping Date Fields in Pivot Table RuthBetts Excel Discussion (Misc queries) 2 August 26th 07 07:44 PM
Grouping Date Data in a Pivot Table Raymond[_2_] Excel Worksheet Functions 1 June 26th 07 09:04 PM
Grouping By Date in Pivot Table Shams Excel Worksheet Functions 8 December 7th 05 07:15 PM
Pivot table-date grouping Dan Excel Discussion (Misc queries) 3 December 29th 04 09:23 PM


All times are GMT +1. The time now is 08:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"