Pivot Table

[#1]

Hi All,

I want to compare the column with previous column value and have to give the backround color based on that. (See the attchment).

Any idea for that?

[Anonymous]

HI,

using this expression if(column(1)=column(2),Yellow(),if(column(1)>column(2),Red(),green())

in background color condition in column(2) expression you need to column no to change based on your table.,

[#3]

Hi Srikumar,

Thanks for reply.But Its not different columns (expressions). Its same expressions with different dimensions means Build1 and Build2 are the data under Build dimension.So I cant use this expression.

[#4]

hi,

you can use above function.

[Anonymous]

Hi Tamil,

if(Build='Build2',

if(sum({$<Build={"Build1"}>}value)>sum({$<Build={"Build1"}>}value),red(),

if(sum({$<Build={"Build1"}>}value)=sum({$<Build={"Build1"}>}value),Yellow(),

if(sum({$<Build={"Build1"}>}value)<sum({$<Build={"Build1"}>}value),Green()

))))

use Expression in the Expression Background color,

it will helpful ..,