Help with background color gradient in pivot table
I am trying to implement background color gradient based on an expression values in a pivot chart. I would like to get the pivot to look like this:
Lowest value is Red and max is green. All +ve values are shades of green and -ve values shades of red.
Also the values are formatted to show as '#.00%' but the shading is based on the exact values. That's why you can see that some of the cell have a shade even though the value appears to be '0.00%'. (as shown in the 2nd screen grab attached.
Any help on how I can achieve this in my chart. I have played around with colormix but cant get it to work as required.