Hide Rows with Zero values without using INCLUDING ZERO VALUES

[Nittin16]

Hi Team,

Is it possible to hide rows which has 0's in straight table without using  INCLUDING ZERO VALUES ? 

Eg:

Desc, Amount

A,0

B,0

C(A+B), 0 

D,1

E,2

Requirement is A and  B row should be hidden if they are zeros  and C (A+B) should be shown on the table if it is zero.

[rubenmarin]

Hi, maybe setting null() in the expression, but you will need extra checks, like:

If(Match(Desc,'A','B')
  ,If(Sum(Amount)=0
    ,Null()
    ,Sum(Amount)
  ,Sum(Amount)
)