Heatmap pivot table

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Heatmap pivot table

sergio0592 — Tue, 02 Jul 2019 15:18:17 GMT

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)