Color Mix per Dimension

[venelin_rs]

I want to use color mix function in pivot table and I want to be on the dimension level (in this case product).

For example, I want to know which is the max and which is the min for each product in the last 10 days.

Please see the attachment.

[bc-thebruuu]

Please take a look at the attachment

The backgrouod color of the expression contains the logic for background

and the font color too

In this way, you get what you shown on the Excel File

BUT this isn't colormix as colormix will set colors depending on how far/near you are far the min/max ...

[venelin_rs]

Thank you Bruno.

It's a good solution, but I have to upgrade that to be some kind of color mix.

Min result to be in red color and the max to be in green color as your example. So it's good first step

Now I have to put color to all values between min and max.

[bc-thebruuu · Accepted solution]

HI

You just need to use the min and max functions I wrote in the colormix wizard

Here's the result ...

[venelin_rs]

That is exactly what I'm looking for.

Thank you Bruno.