Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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