S
Sajith
HI,
I have a doubt in excel pivot tables. I have "Year"
dimension in Page Area. Month and Week date dimension in
Row area. There are some old data is displaying in week
date. I dont want to change the pivot table design for
this as data is huge. Want to know if a macro can help in
this matter.
Like If i select YEar dimension in the page area as "2004"
the weekdate should only have data of 2004.
Example :
Below is the current setup
YEAR 2004
MONTH WEEKDATE AMT
JUNE 01/06/2003 0
06/06/2004 56
11/06/2003 0
11/06/2004 78
JULY 01/07/2003 0
06/07/2004 34
11/07/2003 0
11/07/2004 86
I want to chage like the below...Depends on the
dimension..if i run a macro can we change like this.
YEAR 2004
MONTH WEEKDATE AMT
JUNE 06/02/2004 56
11/02/2004 78
JULY 06/07/2004 34
11/07/2004 86
Thanks in advance for any help regarding this..
Regards
Sajith
I have a doubt in excel pivot tables. I have "Year"
dimension in Page Area. Month and Week date dimension in
Row area. There are some old data is displaying in week
date. I dont want to change the pivot table design for
this as data is huge. Want to know if a macro can help in
this matter.
Like If i select YEar dimension in the page area as "2004"
the weekdate should only have data of 2004.
Example :
Below is the current setup
YEAR 2004
MONTH WEEKDATE AMT
JUNE 01/06/2003 0
06/06/2004 56
11/06/2003 0
11/06/2004 78
JULY 01/07/2003 0
06/07/2004 34
11/07/2003 0
11/07/2004 86
I want to chage like the below...Depends on the
dimension..if i run a macro can we change like this.
YEAR 2004
MONTH WEEKDATE AMT
JUNE 06/02/2004 56
11/02/2004 78
JULY 06/07/2004 34
11/07/2004 86
Thanks in advance for any help regarding this..
Regards
Sajith