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]

Here you have an example. If you need something else please let us know by your example

[#3]

hi,

Hide a row in straight table

[mmonfort · Accepted solution]

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?