Only negative expression in pivot table

[#1]

Hi, my English is not very good but I hope you can understand and help me.

I have a pivot table with multiple expressions that sum various data, one of the expressions acts as a total of the others expressions. What I do is only show rows

where this total is negative, Example:

Harvest	Species	Expression 1	Expresion 2	Expression 3	Expression (Total)
09/10	SOY	100	5	-90	15
09/10	CORN	100	-50	-90	-40
10/11	WHEAT	50	-20	-50	-20
10/11	CORN	80	-30	-10	40
11/12	SOY	80	-30	-50	0

What I need is that the table is as follows:

Harvest	Species	Expression 1	Expression 2	Expression 3	Expression (Total)
09/10	CORN	100	-50	-90	-40
10/11	WHEAT	50	-20	-50	-20

Any suggestions?

Thank you very much in advance. Greetings.

Luciano.-

[#2]

Hi Luci,

           I did not understand  what you asked above, Can you explain me clearly.

Regards,

Antony.

[#3 · Accepted solution]

Hi Luciana,

               Please find attached application as per your requirement.

Hope this is the one you asked.

Regards,

Antony.

[rohit214]

hi luci

use this expression in your pivot table

if(Expression (Total)<0,Expression (Total),0)

and in Proreties>> presentation>>Spress zero values

may it helps you

thanks

rohit

[SunilChauhan]

if(Expression (Total)<0,Expression (Total),0)

and presentation-Spress zero values

[#6]

Pardon for my bad English, that's exactly what I was looking for.

Thank you very much everyone.

Greetings from Argentina.

Luciano.-