Hiding rows in a straight table

[ajithsachin]

Hi All,

     I have a straight table and i need to suppress rows as per my expression.

     Example i have a sum(amount) expression and need to show the rows only sum(amount)>1000 with out set analysis.

     is there any other option..?

[ariel_klien]

Hi

You can try:

if(sum(amount)>1000,sum(amount),null())

BR

Ariel

[#3]

try this

if(sum(amount)>1000,sum(amount),' ')

or try this

if(sum(amount)>1000,sum(amount),0)

[er_mohit · Accepted solution]

try this

sum(if(amount>1000,amount,0))

and make sure in presentation tab check on supress null value

the other way to do this on dimension tab write there for one dimension

in add calculated dimension that

aggr(if(amount>1000,Dimensionfield),Dimensionfield))

in label side write the name of Dimensionfield

make sure check on suppress null value

[padmanabhan_ram]

if you can perform it in the script level then try using Set HidePrefix = %;

and use %field name in the expression.. hope this helps you.