Filter based on two dimensions
Need your help on below query -
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?