Colormix in heat map

[sifatnabil]

Hi all,

I made a cross table by using 2 dimensions (SessionID and Customer) and dragging SessionID to the top to create a "heat map". I used a dummy expression like ='x'. In the expression background colour, I'm using:

=ColorMix1(sum(Sales)/max(aggr(sum(Sales),SessionID,Customer)),white(),rgb(0,70,140))

But this doesn't show the correct colours. How can I amend ColorMix1() such that it takes the highest sum(Sales) of a Customer from the SessionIDs it participated in as the maximum value? This way, the heat map can show customer sales performance on a session by session basis. Thanks.

[vkozlov]

Hi

Try to use this example

[sifatnabil]

Hi vkozlov‌, I was actually using this example. But how can I make it such that the max value is the max within a single month? e.g. a max for January, February, March, etc. This example has a global max value for the entire data set.