1.Any idea how i can sort descending on the % difference column ?
2. Any idea how to display the % difference column with RED (when >=0) and GREEN (when <=0) ?
Use this calculated filed
IF SUM([Profit])>=0 then "Green"
and drag it to color shelf and assign Green and Red color
I hope this will work for you.
Thanks and regards,
Thanks Rohan. I tried this already. The measures are not showing the option to "sort". The sort icon is grayed out when i select any measures.
Thanks Rohan. Since the % difference is calculated based 2 different metrics which are again %, the new calculation to say green or red is erroring out saying "numeric field is required".