Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - I am using to the colour mix wizard on a pivot table.
The pivot has 2 dimensions - when I display the pivot with the two dimensions as rows (right hand side) I get the desired result.
When I display the pivot with rows and columns - I get a different result - I notice the formula is using a row count which I am guessing is the cause of this.
Any idea how to get solve this?
Nandy
HI Nandy,
Your formula is based on the range of values.ie your Profit (Check formula pasted below)
Formula is working correct. e.g for customer product 1 has minmum value hence it reflects red and same reflected in both of your graphs.
if Your value came in a range than it show similar result, else you have two colours for min and max ie. Red and Green.
Hope it clears your doubt.
below formula is pasted :
ColorMix1 ((1+Sign(2*(sum(PROFIT)-RangeMin (top(total sum(PROFIT),1,NoOfRows(total))))/(RangeMax (top(total sum(PROFIT),1,NoOfRows(total)))-RangeMin (top(total sum(PROFIT),1,NoOfRows(total))))-1)*Sqrt(Fabs((2*(sum(PROFIT)-RangeMin (top(total sum(PROFIT),1,NoOfRows(total))))/(RangeMax (top(total sum(PROFIT),1,NoOfRows(total)))-RangeMin (top(total sum(PROFIT),1,NoOfRows(total))))-1))))/2, ARGB(255, 255, 0, 0), ARGB(255, 0, 255, 0))
Hi - My issue is on Customer 2, product A, it has a different colour depending on how the pivot is displayed.
I would like the colours to be as the second pivot, but displayed in the format in the first pivot.
Thanks
Nandy
Hi , I have changed your both the graphs and found that this is showing the same colour. Because it calculates the same as per the parameters you have set.
I don't!!
Found a solution