Heatmap pivot table

[hopkinsc]

Hi all,

I have the following expression in a pivot table..

if(Selection = 'Best, ValBest / 1000,

if(Selection=Group, ValGroup / 1000,

if(Selection=Target, ValTarget / 1000

)))

There are positive and negative values in the results,

I want to colour it like  a heatmap but i am struggling to get it to work. 

I have used the wizard but the colours are not working at all (it stays white)

my upper limit is the MAX() of the value depending on the selection chosen..

if(Selection = 'Best, MAX(ValBest) / 1000,

if(Selection=Group,max(ValGroup) / 1000,

if(Selection=Target, MAX(ValTarget) / 1000

)))

and the lower limit is the MIN() of the value depending on the selection chosen. 

if(Selection = 'Best, MIN(ValBest) / 1000,

if(Selection=Group,MIN(ValGroup) / 1000,

if(Selection=Target, MIN(ValTarget) / 1000

)))

Can anyone help please?

[sergio0592]

Hi,

In the background color formula, you can use  instead the 'a value' of argb function:

argb((sum(ValBest)/Sum(TOTAL ValBest))*255,255,128,128)