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.

"Tiya" wrote:

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