Show values below 5000
I have a crosstab with three dimensions and one measure. I would only like to show numbers below 5000, however if I have one item (my first dimension) where one company is below 5000 and the other isn't, I would like to show both companies. So in this case, I don't want CZ 69,952 to disappear.
I guess this should be possible with a visibility agent, I just don't get the right syntax.
Thanks in advance 😊
0
Comments
Hi Karoline,
Not sure if it could work, but maybe you could create a new calculation and have a measure showing the max for each level (company). Now you could use your visibility agent to hide members when the new calculation is below 5000?
Â
You can create a calculation that gets the min of the siblings and use that calculation for your visibility agent. Something like Min(d-1, all(s), m1) should work.
Â
Please sign in to leave a comment.