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:
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.
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.