Yes, it's hard to analyze the relationships and create appropriate view with different aggregation level.
Here is the result of my trial and errors, anyways.
Only one value and max, min, avg all works. (sum is NG)
Above three fields, set table calc as below.
Sales vs Target_SM_10.0.twbx 331.1 KB