How to Create HitMap

[RK121]

Hello, 

Does anyone know how to apply a colormix wizard for the whole data set inside of the table with 1 measure (count (Sales), I don't know how to do it for one expression, colors should apply depending on the value behind: strong color for the highest and so on...

But I need to apply range for the whole table.

Now with the Colormix Wizard feature I have this (as you could see it looks at each column (highest-lowest):

ColorMix1 ((1+Sign(2*(count([Sales])-RangeMin (top(total count([Sales]),1,NoOfRows(total))))/(RangeMax (top(total count([Sales]),1,NoOfRows(total)))-RangeMin (top(total count([Sales]),1,NoOfRows(total))))-1)*Sqrt(Fabs((2*(count([Sales])-RangeMin (top(total count([Sales]),1,NoOfRows(total))))/(RangeMax (top(total count([Sales]),1,NoOfRows(total)))-RangeMin (top(total count([Sales]),1,NoOfRows(total))))-1))))/2, ARGB(50, 242, 0, 0), ARGB(255, 242, 0, 0))

But I am trying to apply heatmap for the whole set, like this

Please give any suggestions how to do it.

Thank you