Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
So i made a pivot table and for 1 dimension, i made a conditional color for the background.
problem is: it also fills the 'Total' field.
how do i make this go away?
see attached image for clarification..
thanks"
Dick
If(rowno()=0 or isNull(rowno()),Null(),If(Sum(Sales) > 300,Red(),Yellow()))
try this go to settings->user preference->design
and change default styling mode default to advanced
and now right click on the total cell and click on custom format cell and change the Background color for the total cell
What is your background color expr?
try this
if ( expression > 1,red(),green())
Vikas
pfa
If(rowno()=0 or isNull(rowno()),Null(),If(Sum(Sales) > 300,Red(),Yellow()))