LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnson748r
 
Posts: n/a
Default grouping data in pivot tables

I am trying to group some dates in a pivot table, however when I select the
field, right click and select "group", I get an error - "Can't group that
selection". I have checked that the field is formatted correctly (dates). Any
suggestions?
 
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
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM
ARRANGING DATA IN PIVOT TABLES [email protected] Excel Worksheet Functions 1 September 20th 05 10:18 AM
need pivot tables to look more like crosstabs with repeating data. skeekath Excel Discussion (Misc queries) 1 August 23rd 05 10:28 PM
show items with no data option in pivot tables AHuntington Excel Discussion (Misc queries) 2 August 23rd 05 01:30 PM
Do Pivot Tables have an automatic data range expansion? David.c.h Excel Discussion (Misc queries) 1 March 26th 05 12:55 AM


All times are GMT +1. The time now is 11:31 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"