topic Re: Pivot Table: Color code in App Development

Pivot Table: Color code

Anonymous — Wed, 24 Jan 2018 21:29:20 GMT

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

Re: Pivot Table: Color code

petter — Wed, 24 Jan 2018 21:34:45 GMT

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

Re: Pivot Table: Color code

Anonymous — Wed, 24 Jan 2018 21:36:53 GMT

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