Grouping Dates in Pivot Table

  • Thread starter Thread starter JohnL
  • Start date Start date
J

JohnL

I have quite a large data set that I would like to
summarise by month in a pivot table. Following the help
menu seems to work up to a limited number (around 350
rows) After this I get an error message 'Cannot Group
that Selection.' Does anyone know a way round this? In
the main data I need to keep the full date e.g. 10/11/03.

Thanks in advance

John
 
John,

Worked OK for me for 5000 rows.

For grouping dates, I think you have to define the source data exactly. You
can't use eg: $A:$B, or $A$1:$B$5000 if you only have entries up to row
4500.

HTH,
Andy
 
JohnL said:
I have quite a large data set that I would like to
summarise by month in a pivot table. Following the help
menu seems to work up to a limited number (around 350
rows) After this I get an error message 'Cannot Group
that Selection.' Does anyone know a way round this? In
the main data I need to keep the full date e.g. 10/11/03.

Thanks in advance

John
Click to expand...

Usually you get that error message when one (or more) of the things you are
trying to group is not the same as the others, for example a text string
amongst dates. Could it be that one of your 'dates' around row 350 is
actually text that just looks like a date?
 
Hi,

Why don't try to add a column to your data sheet and enter the formula =TEXT(<your date column>, "mmmm"). and reorganize your pivottable. When I work on huge data with pivottables, I walk around the grouping problem of months by using this formula.


--
Regards

Haldun Alay

To e-mail me, please remove AT and DOT from my e-mail address.



"JohnL" <[email protected]>, iletide sunu yazdi I have quite a large data set that I would like to
summarise by month in a pivot table. Following the help
menu seems to work up to a limited number (around 350
rows) After this I get an error message 'Cannot Group
that Selection.' Does anyone know a way round this? In
the main data I need to keep the full date e.g. 10/11/03.

Thanks in advance

John
 
Back
Top