Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a straight table with 7 dimensions and 5 expressions. I want to hide rows of the straight table based on 1 expression(its amount > 10) How can I achieve this. I only want to see rows where the expression amount is greater than 10.
Really appreciate any help.
I had something similar as well - I had 2 expressions that needed conditions on them.
If I were you I'd write it like this
Expression 1:
if(sum(Amount)> 10,
if(sum(Profit)> 2,
sum(Amount) ))
Expression 2:
if(sum(Amount)> 10,
if(sum(Profit)> 2,
sum(Profit)))
Does that work for you?
if (sum(Amount) > 10,sum(Amount))
Where should I add this? Expression or Dimension?
In the expression
Send otherwise an example if you like
Per Francis' response and depending on your data you might still see those dimensions show up - if that's the case make sure on the dimensions you have ticked the "suppress when value is null" check box
Thanks, it worked. But now I have 2 expressions, and I need to have a check on both Amount and profit and hide rows if both Amount>10 and Profit > 2. How can I achieve this?
If I'm putting condition on both, it is still showing even if Amount >10 and Profit <2.
Can you post the full expression you are using in evaluating this condition. Use OR instead of AND and try?
There are two different expressions which are creating Amount and profit. Where should I put the AND or OR condition?
Can you share a sample app if possible please ??