cancel
Showing results for 
Search instead for 
Did you mean: 

Filter based on two dimensions

sridevi_p
Active Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Sri,

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

Shrikant