Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have a straight table where I have a dimension-Store_Name
Expressions-Sales/margin/Net Sale Qty
whenever a measure will be selected the chart will represent the bottom stores based on the measures value-i-e the stores will be sorted in the ascending order.
Now my problem is that I want to color the most bottom store as the darkest color,the color will be lighter when the stores values will be increasing gradually.i-e-If the bottom stores have values 100,200,300,400,500...then 100 will be darkest red,200 will be a little bit lighter,and so on..
Please help.
Try something like this
If(Sum(Sales) = 100, LightRed(), If(Sum(Sales) = 200, ...., LightGreen()))
OR Please post sample application