Olap Report problem

S

Sajith

hi

let me say thanks first for replying to my query...I will
try to explain my doubt by making it more simpler.

Month & week date is single 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 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...after the macro

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
 
D

Dave Peterson

See one response at your other thread.
hi

let me say thanks first for replying to my query...I will
try to explain my doubt by making it more simpler.

Month & week date is single 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 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...after the macro

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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table help needed.... 9
Pivot table doubt 1
How to Round a Date to a Month 2
Count based on multiple criteria 2
Formula in excel 1
macro to add numbers based on set criteria 6
Avg/date 2
Conditional sum on an array based on another array 3

Top