Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default pivot tableproblem in grouping

i want group a date, but the message comes that " u cannot group the selection.

whats the reason can anyone help on this.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default pivot tableproblem in grouping

There is at least one cell that is not a date--it may be empty, it may contain
text. But it's not a date.

hitesh wrote:

i want group a date, but the message comes that " u cannot group the selection.

whats the reason can anyone help on this.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default pivot tableproblem in grouping

Check out this link...

http://www.contextures.com/xlPivot07.html
--
HTH...

Jim Thomlinson


"hitesh" wrote:

i want group a date, but the message comes that " u cannot group the selection.

whats the reason can anyone help on this.

Reply
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
pivot table and grouping cricket7 Excel Discussion (Misc queries) 4 July 30th 07 08:56 AM
Grouping Problem in Pivot ADub Excel Discussion (Misc queries) 3 September 8th 06 03:04 AM
grouping in pivot tables LynnFree Excel Discussion (Misc queries) 2 May 18th 06 03:54 AM
pivot grouping BorisS Excel Discussion (Misc queries) 1 September 12th 05 09:00 PM
Pivot date grouping sue Excel Discussion (Misc queries) 4 February 27th 05 09:43 PM


All times are GMT +1. The time now is 07:41 PM.

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

About Us

"It's about Microsoft Excel"