Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
HI
You just need to use the min and max functions I wrote in the colormix wizard
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 ...
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.
HI
You just need to use the min and max functions I wrote in the colormix wizard
That is exactly what I'm looking for.
Thank you Bruno.