Also just noticed an error with my Color Coding formula - it should be [Budget Sales] rather than [Sales]. Sorry all!
So until 10.2 (I still don't know exact feature anyways)
This is quite troublesome approach, but provide something.
Need to duplicate data twice to get measure value as dimensions.
I could not take this approach from your original data, then I copied your data into clipboard.
Create three calculated field
[SM_Number of Record]
if [Table Name]="Clipboard_20170111T162234.txt" then 1 end
if attr([Table Name])="Clipboard_20170111T162234.txt1" then sum([Budget Sales]) end
if attr([Table Name])="Clipboard_20170111T162234.txt2" then sum([Budget Margin]) end
[Sales Color (copy)]
if attr([Table Name])<>"Clipboard_20170111T162234.txt1" then "NA"
elseif sum(Sales)>lookup(sum(Sales),-1) then 'Green'
elseif sum(Sales)<lookup(sum(Sales),-1) then 'Red' else 'Grey' end
ColorCodingColumns_JS_SM_10.1.twbx 472.4 KB
2 of 2 people found this helpful
Thank you, Shin! I'll experiment today and will report back.