Skip to Content

Filter based on two dimensions

Dear friends,

Need your help on below query -

Dimension #1:

A1

A2

A3

B1

B2

Dimension #2:

C1

C2

D1

D2

Apart from this I have the 'Time' dimension.

Now I need to build report with -

Row axis:  Dimension # 1 & #2

Column axis: Time

However, my requirement is -

If my Dimension#1 starts with A*, then applicable Dimension#2 are C1 & C2

If my Dimension#1 starts with B*, then applicable Dimension#2 are D1 & D2

I have 20K rows in Dimension#1 and it is really not possible for me to do Keep & exclude manually.

Also, I tried VBA code to delete rows.  This is very time consuming.

Is there any way to handle this scenario within epm add in?

Pl. help.

Thanks.

Regards,

Sri

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 27, 2014 at 05:45 PM

    Hi Sri,

    Kindly explain the requirement with the help of desired screen shot.

    Shrikant

    Add comment
    10|10000 characters needed characters exceeded