Dimension limitation with expression

[philgood34]

Hi everybody

I have a table with a dimension (SECTORS) and 2 measures ( CIB_CATTC & CATTC_REEL)

i want to select the sectors with CATTC_REEL< CIB_CATTC and be able to display only these sectors

So i tried to use the dimension limitation as shown

don't work 😞

anybody have an idea ?

regards

Phiilippe

[karthikoffi27se]

Hi Philippe,

Please use the below expression  in your measure

=IF(CATTC_REEL< CIB_CATTC ,CATTC_REEL,0)

=IF(CATTC_REEL< CIB_CATTC ,CIB_CATTC ,0)

and in addons please disable the show zero values.

Many Thanks

Karthik

[philgood34]

Hi Karthik ,

great trick !

obviously i added sum( ...) , and it's working !

i thank's you for that

the disadvantage is when i have 10 more measures with aggr expression for example, i have to apply the trick for all ... rather complicated

Anyway ... if there's no alternative with the dimension limitation or other fonctionality , i take your trick !

best regards

Philippe

[its_anandrjs]

You can do this calculation in the load script if you have many calculations on the script part you can handle it properly and it is optimized way as well.