crate group of date, with Dynamic Range in Pivot Table but not wor

[Guest]

Hi
When i crate group of date, with Dynamic Range in pivot table it's not
working.

I am useing Pivot Table to create data where i am useing Date,Party
Name,Group,Wt.,Rate,Amt.

In this Data i have given range name (database) with Dynamic Range
=OFFSET(Sheet1!$A$5,0,0,COUNTA(Sheet1!$A:$A),6)

But when i use Date in report i try to create Group of date in month or year
or day and qty it says can't create a gorup?

Any help how to crate group of date, with Dynamic Range?

Thanks

Tiya

 

[Dave Peterson]

You may want to look at the responses to your post in .misc.

 

[Guest]

We had this same problem with absolutely clean data,. Data was formated as
date fields etc. In looking at sample data from K2 Enterprises they had the
raw data formatted as custom "MMM-YY" (highlight data, format, cells,custom,
select mmm-yy) and then we got the group by dialogue box. Don't know why, it
just worked.

 

[Guest]

I don't now if this is too late or if you've had an answer beyond these two,
but one thing I have learned is that you want to make sure that there are NO
BLANKS in your column containing Date data. As well, even with a RAW Excel
report, you want to make sure that you don't have any blank rows. Both of
these issues will cause the error you're encountering.