Hide Rows based on expression in a Straight Table

[#1]

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.

[francisvandergr]

if (sum(Amount) > 10,sum(Amount))

[#3]

Where should I add this? Expression or Dimension?

[francisvandergr]

In the expression

[francisvandergr]

Send otherwise an example if you like

[mmonfort]

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

[#7]

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.

[vishsaggi]

Can you post the full expression you are using in evaluating this condition. Use OR instead of AND and try?

[#9]

There are two different expressions which are creating Amount and profit. Where should I put the AND or OR condition?

[vishsaggi]

Can you share a sample app if possible please ??