Pivot Table: Color code

[Anonymous]

Hi everyone,

I am trying to color code my pivot table. The value are ranging from -1 to 1. i try to make the data above 0 in Green and below 0 in red. And the same time, the color is also value associated.

the current expression i use is:

ColorMix2(Sum({$<country_cde={"us"}>}[pivot_data.value])/before(Sum({$<country_cde={"us"}>}[pivot_data.value]))-1,RGB(128,0,0),rgb(0,100,0))

but the color is showed is below:

any suggestion?'

Thanks,

Nathan

[petter]

Do you have a sample app or sample data we could tweak - so you get some suggestions quicker?

[Anonymous]

  ... no .. and i could not share the original data. sorry about that.