Total column need in color

[soniasweety]

Hi All,

i want to show the Total column in  colour  

i tried custom format cell but am getting only dimensions with the required color 

how to show   total column as colour ?

Thanks

Sony

[sibin_jacob]

Go to expression tab -> Click on '+' symbol -> then Background Color

if (isnull(rowno()),RGB(0,255,0))

[sibin_jacob]

if it is a pivot table try this one

If(dimensionality()  = 0,RGB(0,255,0))

[soniasweety]

Hi

if (isnull(rowno()),RGB(0,255,0))   this is working for that perticular expression only.

but i need entire total column as same color.

Note:  its stright table.

[sibin_jacob]

In that case, you need to give this formula in all the expressions and dimensions.

if (isnull(rowno()),RGB(0,255,0))

Go to dimension tab -. Click on '+' symbol -> then Background Color

[soniasweety]

not worrking