I need help with of Concat Discinct of a Field with a Sort-Weight?
The default is A-Z.
What I want is to sort by Total Absolute amount
i.e. The sort order should be as per below
But the best I can get is sorted by individual Absolute Amount – so it’s not distinct, values are repeated
it's sorted like below (not the Sum of the Amounts)
I think the answer maybe something to do with Aggr but I can’t work it out. Any ideas? See attached for sample data.