pivot table expression

[#1]

Hi,

I need a help with expression, I would like to have in pivot table only rows, where sum of row in pcs (ks)  is bigger than certain value, for example 10.

Another question :  how to do conditional formatting without formatting of total column. It is possible?

[er_mohit]

in expression tab where you add expression you see + icon expand it for that expression field you 'll see the background color and text format etc put your condition here

like for background color

if(your expression >10,green(),rd())

hope it helps

[vikasmahajan]

Go to expression -> Background Color ->

you can put conditions like  following

=if(column(3)>0.001 and column(2)>0.001,if(column(3)>column(2),rgb(0,182,0),rgb(247,247,247)),0)

to display particular column in specific colour.

Hope this help u

Vikas

[#4]

thanks, maybe I describe it in bad way, but actually I have only 2 columns and I need to remove conditional formatting from total column, which is on the left side of table