software

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
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 wrote:
gt;
gt; Hi
gt; When i crate group of date, with Dynamic Range in pivot table it's not
gt; working.
gt;
gt; I am useing Pivot Table to create data where i am useing Date,Party
gt; Name,Group,Wt.,Rate,Amt.
gt;
gt; In this Data i have given range name (database) with Dynamic Range
gt; =OFFSET(Sheet1!$A$5,0,0,COUNTA(Sheet1!$A:$A),6)
gt;
gt; But when i use Date in report i try to create Group of date in month or year
gt; or day and qty it says can't create a gorup?
gt;
gt; Any help how to crate group of date, with Dynamic Range?
gt;
gt; Thanks
gt;
gt; Tiya

--

Dave Peterson

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

quot;Dave Petersonquot; wrote:

gt; Depending on what's in A1:A4, your range may be longer than you think.
gt;
gt; If you hit Edit|goto and type Database, what get's selected.
gt;
gt; I'd modify the formula to only look at $a$5:$65536:
gt;
gt; =OFFSET(Sheet1!$A$5,0,0,COUNTA(Sheet1!$A5:$A65536) ,6)
gt;
gt; Tiya wrote:
gt; gt;
gt; gt; Hi
gt; gt; When i crate group of date, with Dynamic Range in pivot table it's not
gt; gt; working.
gt; gt;
gt; gt; I am useing Pivot Table to create data where i am useing Date,Party
gt; gt; Name,Group,Wt.,Rate,Amt.
gt; gt;
gt; gt; In this Data i have given range name (database) with Dynamic Range
gt; gt; =OFFSET(Sheet1!$A$5,0,0,COUNTA(Sheet1!$A:$A),6)
gt; gt;
gt; gt; But when i use Date in report i try to create Group of date in month or year
gt; gt; or day and qty it says can't create a gorup?
gt; gt;
gt; gt; Any help how to crate group of date, with Dynamic Range?
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Tiya
gt;
gt; --
gt;
gt; Dave Peterson
gt;

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?
Tiya wrote:
gt;
gt; Thanks Dave Peterson
gt; In Range A1:A4 i am usring Advance Filter criteria my data start from A5 i
gt; have modify formula but it's not working. it till says can't group that
gt; selection.
gt;
gt; If you say i can send example file?
gt;
gt; Thanks
gt; Tiya
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Depending on what's in A1:A4, your range may be longer than you think.
gt; gt;
gt; gt; If you hit Edit|goto and type Database, what get's selected.
gt; gt;
gt; gt; I'd modify the formula to only look at $a$5:$65536:
gt; gt;
gt; gt; =OFFSET(Sheet1!$A$5,0,0,COUNTA(Sheet1!$A5:$A65536) ,6)
gt; gt;
gt; gt; Tiya wrote:
gt; gt; gt;
gt; gt; gt; Hi
gt; gt; gt; When i crate group of date, with Dynamic Range in pivot table it's not
gt; gt; gt; working.
gt; gt; gt;
gt; gt; gt; I am useing Pivot Table to create data where i am useing Date,Party
gt; gt; gt; Name,Group,Wt.,Rate,Amt.
gt; gt; gt;
gt; gt; gt; In this Data i have given range name (database) with Dynamic Range
gt; gt; gt; =OFFSET(Sheet1!$A$5,0,0,COUNTA(Sheet1!$A:$A),6)
gt; gt; gt;
gt; gt; gt; But when i use Date in report i try to create Group of date in month or year
gt; gt; gt; or day and qty it says can't create a gorup?
gt; gt; gt;
gt; gt; gt; Any help how to crate group of date, with Dynamic Range?
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt; Tiya
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson