Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table doubt
hi
I have one doubt. I have Month & week date as asingle dimension. Week date is the child of Month. using a macro can i unselect the all the weekdate whose year is 2003 ? below is the current set up MONTH WEEKDATE AMT JUNE 01/06/2003 23 06/06/2004 56 11/06/2003 91 11/06/2004 78 JULY 01/07/2003 23 06/07/2004 34 11/07/2003 54 11/07/2004 86 I want to change like the below...after the macro runs JUNE 06/06/2004 56 11/06/2004 78 JULY 06/07/2004 34 11/07/2004 86 Thanks in advance for any help regarding this.. Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table doubt
Sajith,
Spend a very little time and set up your database with all the information that you need for proper filtering: somply add a column with the formula =YEAR( cell with the date ) and then you can use that column as a Row Field or even as the Page Field. HTH, Bernie MS Excel MVP "Sajith" wrote in message ... hi I have one doubt. I have Month & week date as asingle dimension. Week date is the child of Month. using a macro can i unselect the all the weekdate whose year is 2003 ? below is the current set up MONTH WEEKDATE AMT JUNE 01/06/2003 23 06/06/2004 56 11/06/2003 91 11/06/2004 78 JULY 01/07/2003 23 06/07/2004 34 11/07/2003 54 11/07/2004 86 I want to change like the below...after the macro runs JUNE 06/06/2004 56 11/06/2004 78 JULY 06/07/2004 34 11/07/2004 86 Thanks in advance for any help regarding this.. Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Doubt about pivot table | Excel Discussion (Misc queries) | |||
doubt | Excel Worksheet Functions | |||
I have a doubt! | Excel Discussion (Misc queries) | |||
some doubt | Excel Worksheet Functions |