How to filter Table only display those Row Debt more then sales ?

[paulyeo11]

Hi All

I have a table display debt and sales.

I want to only filter when debt is more then sales.

Diamension :-

=company

Expression :-

(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))/1000

sum(if(L5M='-1',sales/1000))

I have try below expression :-

=If

(

(

sum(if(L5M='-1',sales/1000))

)

>

(

(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))/1000

)

,company)

it does not work

Paul

[paulyeo11]

my QV Doc

[tamilarasu · Accepted solution]

Hi Paul,

Check the attachment.

[paulyeo11]

Hi Tamil

Thank you very much , it work.

Paul