Hide entire row in straight table

[Srinivas]

Hi All,

i am trying to hide entire row where expression value is "zero or null" , but i couldn't find the solution. PFB Screen shot

see above scree highlighted yellow rows should be hide. this is my requirement.

My output is see below screen shot:

Advance Thanks ,

munna

[jagan]

Hi,

Try this expressions

Sales=If(sum(sales) <> sum(Qty), sum(sales))

Qty =If(sum(sales) <> sum(Qty) AND sum(sales) > 0, sum(Qty))

Test = If(sum(sales) > 0, Column(1))

Regards,

Jagan.

[ecolomer]

See this:

[#4]

Another possible variant (may be helpful for avoiding modifying all expressions) - apply the condition once, in last dimension:

and check the box "suppress when value is null" for that dimension.