This content has been marked as final. Show 2 replies
Came across a weird one, not sure if I'm doing something wrong here.
Scenario is simply, I have a dimension (Agents) and an Amount.
If I show (in a table) Agent by Sum(Amount) then I am able to sort the agents by the highest amount.
If I add another measure (a calculation like RangeSum(Above(...)) ) then the sorting stops working.
In the screenshot the Left Table only sorts by Sales Person name (even though the marker shows sort by Sum(Amount))
the right hand table is what it should look like.
Anyway to get around this so that I can sort with other measures?