2 color gradients in pivot chart

[ZoeM]

Hi Community,

I am having trouble with formatting the background of cells for a pivot chart. I would like to utilize the two color gradient coloring and set a condition so that based on the item, the cell background changes accordingly.

Please view the attached dashboard. 

I have three different color scales I would like to institute and I do not know how to do the gradient version. 

Any help rendered will be truly appreciated. 

[PabloTrevisan]

Hi. Try this expression color:

ColorMix1( rank(total column(1))/noofrows(TOTAL) , rgb(0,0,205), rgb(250,128,114))

[ZoeM]

Sorry for the late response Pablo.

I tried using your expression and I could not get it to work in the sample