Font color in Pivot

[stekol61]

Hi!

I have data in a pivot table and i have also loaded target values for each record.

If a value in the pivot is below he target the font color should be Red, otherwise it should be Green.

How can this be done in Sense?

[tush]

Hi,

     try it:-

if(sum(value) >= sum(target), red(), green())

Thanks

Tushar

[stekol61]

Hi!

I tried this but it turns all record to Red.

I QV I use this expression, but I can't get it to work in Sense

If ($(v_DS_4G) < If(Len(Only(Country))>0,

num(Only( {$<kpi_item = {'ds_4g'}>}value/1000),'# ##0,00'))

,v_rgb_red, v_rgb_green)

'kpi_item 'and 'ds_4g' are from the loaded target file

[jobsonkjoseph]

Hi, try this

If ($(v_DS_4G) &lt; If(Len(Only(Country))&gt;0, num(Only( {$}value/1000),'# ##0,00')) ,red(),green())

[stekol61]

Hi!

Still not working.

I used my QV expression (kpi) in a table and replaced color with '1' or '0' and this seems to work. see below