PIVOT TABELS!!!!!

[AJMalta]

I'm tearing my hair out!!

I am having problems grouping my data. It is in date format and therefore I want to group by month. I have done this before on other files but when I try to do it now i get the message "cannot group selected data". I have checked the formatting etc etc and I don't know where elese to go!
Can you help??

 

[Mark W.]

On 2002-04-25 08:45, AJMalta wrote:
I'm tearing my hair out!!

I am having problems grouping my data. It is in date format and therefore I want to group by month. I have done this before on other files but when I try to do it now i get the message "cannot group selected data". I have checked the formatting etc etc and I don't know where elese to go!
Can you help??

You can't have any blank (empty) cells in your date column. If you do you'll have to replace them with an arbitarily high or low date value, re-create your PivotTable (your existing PivotTable will "remember" the old (blank) cells), and hide your arbitrary date value (or exclude it from your groupings).
This message was edited by Mark W. on 2002-04-25 08:49

 

[AJMalta]

Thanks for the reply. I have checked the data and there are no blank cells. Any other advice?

 

[Mark W.]

On 2002-04-26 01:52, AJMalta wrote:
Thanks for the reply. I have checked the data and there are no blank cells. Any other advice?

What's the Range you are using at Step 2 of 4 on the PivotTable wizard?

 

[AJMalta]

On 2002-04-26 06:56, Mark W. wrote:

On 2002-04-26 01:52, AJMalta wrote:
Thanks for the reply. I have checked the data and there are no blank cells. Any other advice?

What's the Range you are using at Step 2 of 4 on the PivotTable wizard?

It was looking at the whole sheet but I have specified a range now and it works! Thanks for this....
Eternally greatful.