1. TARGIT Community
  2. Community
  3. Frontend, Designer and Consumer
Knowledge Base

Show values below 5000

Karoline Johansen ·

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

2 comments
Sort by DateVotes
  • Sarah Marconatto

    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?

     

    0
  • Danilo Rufino

    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.

     

    0
Please sign in to leave a comment.