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??
