can i show only negative values of an expression in a pivot table?

[chriscools]

Hello,

i have a pivot table with country and client as dimensions.

as expressions i have:

     -sum of creditlimit

     -sum of outstanding invoices

     -sum of creditlimit minus sum of outstanding invoices = available amount to send out

     -sum of amount open orders to deliver

     -sum of amount open orders to deliver minus available amount to send out

if the last expression gives me a negative number, sales and finance department has to see what they will do about it.

How can i limit the table to show me only those clients with a negative number on the last expression?

the others i don't need to see.

thanx!

chris                        

[MayilVahanan · Accepted solution]

HI

Try like this

=if(your exp < 0, your exp)

ex:

if(sum(sales) < 0 , sum(Sales))

Edit:

Apply this condition to all the expression above too