Here is a Design Blog post that may be of some help, but not exactly sure of what you are really trying to accomplish, so a screenshot of what you want may be helpful for others to offer further advice on how to go about things on this one:
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
I have data from 0.01% to 60% and I would like to use color gradient for the entire pivot table (attached). If I use colormix1 function, the colors are almost same as in the attachment.
Color Expression:
colormix1(Sum({$<site= , line =, name ={'used'}>} value) / Sum({$<site= , line =, name ={'manu'}>} value) , green(), red())
.png "Former Employee"){kind=icon}
