Concat DISTINCT with sort-weight

[shane_spencer]

I need help with of Concat Discinct of a Field with a Sort-Weight?

The default is A-Z.

i.e.

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

i.e.

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.

[tresesco · Accepted solution]

Try :

=Concat(Distinct GL_ACCOUNT_CODE_src_1,';', -Fabs(Aggr(NODISTINCT Sum(AMT_NET_TAXREP_src_1),TRANS_INVOICE_NUMBER_src_1,GL_ACCOUNT_CODE_src_1)) )

[shane_spencer]

Thanks - that worked! Are you able to explain what it's doing / why inparticular I need the NODISTINCT ?

[shane_spencer]

Is there a way to do the same in the script?