How to hide my table row with zero value ?

[paulyeo11]

Hi All,

I have a table , i am unable to remove those row with zero value. Hope some one can help me.

Diamension :-

COMPANY_PAY

=If(aging_ar >= 1 and aging_ar <= 30, Dual('1-30', 1),

If(aging_ar >= 31 and aging_ar <= 60, Dual('31-60', 2),

If(aging_ar >= 61 and aging_ar <= 90, Dual('61-90', 3),

If(aging_ar >= 91 and aging_ar <= 120, Dual('91-120', 4),

If(aging_ar >= 121 and aging_ar <= 150, Dual('121-150', 5),

If(aging_ar >= 151 and aging_ar <= 180, Dual('151-180', 6),

If(aging_ar >= 181 and aging_ar <= 210, Dual('181-210', 7),

If(aging_ar >= 211 and aging_ar <= 240, Dual('211-240', 8),

If(aging_ar >= 241 and aging_ar <= 270, Dual('241-270', 9),

If(aging_ar >= 271 and aging_ar <= 300, Dual('271-300', 10),

If(aging_ar >= 301 and aging_ar <= 330, Dual('301-330', 11),

If(aging_ar >= 331 and aging_ar <= 360, Dual('331-360', 12),

If(aging_ar >= 361 and aging_ar <= 390, Dual('41-270', 13), Dual('>12 Mth', 14))))))))))))))

Expression :-

Sum(total_ar)

Paul.

[paulyeo11]

my QVW

[gajapathy74]

hmmm

you have another post How to hide my pivot table whole row with zero value? and hope the solution is helpful.

[paulyeo11]

This is because , after I submit my first post 6 hr , I go and check and found out that it is not appear at forum , so I thou it never send thou , so I resend . Sorry

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo

[gajapathy74]

Okay

[Frank_Hartmann · Accepted solution]

see attached qvw

hope this helps