BG colors in Dimensions URGENT

[dickelsa]

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

[#2]

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

[anbu1984]

What is your background color expr?

[vikasmahajan]

try this

if ( expression > 1,red(),green())

Vikas

[vikasmahajan]

pfa

[anbu1984 · Accepted solution]

If(rowno()=0 or isNull(rowno()),Null(),If(Sum(Sales) > 300,Red(),Yellow()))