Crate group of date, with Dynamic Range in pivot table not working

[Tiya]

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]

Depending on what's in A1:A4, your range may be longer than you think.

If you hit Edit|goto and type Database, what get's selected.

I'd modify the formula to only look at $a$5:$65536:

=OFFSET(Sheet1!$A$5,0,0,COUNTA(Sheet1!$A5:$A65536),6)

 

[Tiya]

Thanks Dave Peterson
In Range A1:A4 i am usring Advance Filter criteria my data start from A5 i
have modify formula but it's not working. it till says can't group that
selection.

If you say i can send example file?

Thanks
Tiya

 

[Dave Peterson]

When I can't group a field, it's because it contains text or empty cells (or
non-numeric data). When you selected that range, did you get what you expected?