Getting the Min(worst) customer name across several dimensions

[#1]

I would like to get the name of our worst customer.

I'm able to get the $ amounts now using set Analysis and

Min(Aggr(Sum{$<>}Amount), Region,Territory,CustomerName).

How to use the same type of expression to get the actual customer name?

Thanks

[shree909]

Try like this

Min(Aggr(Sum({$<cusomer={'Worst cutomer'}>}Amount), Region,Territory,CustomerName).

[#3]

This would not work.  Customer='Worst customer' is a filter and it does not exist.

If it did, it would only show me the dollar amount for the 'Worst customer'.

The Min function will only show me a Min dollar amount.

Thanks

[chematos · Accepted solution]

You can try this:

only({1<Amount={'<=min(Amount)'}>} [customer name])

or

FirstSortedValue([customer Name] ,Amount)

or

aggr(FirstSortedValue([customer Name] ,Amount), Region,Territory)