Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
How to create a %slab range to effect on multiple measures in Pivot or straight table.
For Eg;
Slab_Range:
LOAD * INLINE [
Start, End, Depth_Slab
, 0, 'No Deal'
0, 5,'<= -5%'
5, 10, '-5% to -10%'
10, 15, '-10% to -15%'
15,20, '-15% to -20%'
20,25 , '-20% to -25%'
25,30, '-25% to -30%'
30,35, '-30% to -35%'
35,40, '-35% to -40%'
40,45,'-40% to -45%'
45,50,'-45% to -60%'
50,55,'-50% to -55%'
55,60,'-55% to -60%'
60,65,'-60% to -65%'
65,70,'-65% to -70%'
70,75,'-70% to -75%'
75,80,'-75% to -80%'
80,85,'-80% to -85%'
85,90,'-85% to -90%'
90,95,'-90% to -95%'
95,100,'-95% to -100%'
];
I have four different measures .
A | B | C | D |
-10% | -20% | -15% | -40% |
-20% | -12% | -13% | -20% |
-25% | -15% | -16% | -45% |
-55% | -65% | -70% | -9% |
Whenever I select the slab range that should affect all four measures and the values should be filtered out based on the range selected. I don't want to create 4 different slab ranges for each metric. Single slab range should affect all measures. Could anyone suggest to me how to achieve this logic??
Regards
Krishna
Any clue??