Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
crate group of date, with Dynamic Range in Pivot Table but not wor
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
crate group of date, with Dynamic Range in Pivot Table but not wor
You may want to look at the responses to your post in .misc.
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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
crate group of date, with Dynamic Range in Pivot Table but not
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. -- CSAHP "Dave Peterson" wrote: You may want to look at the responses to your post in .misc. 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
crate group of date, with Dynamic Range in Pivot Table but not wor
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table date group | Excel Discussion (Misc queries) | |||
Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
help how to crate group of date with Dynamic Range? | Excel Discussion (Misc queries) | |||
Cannot group by date in a pivot table | Excel Worksheet Functions | |||
How to group date in pivot table | Excel Discussion (Misc queries) |