Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can try this:
only({1<Amount={'<=min(Amount)'}>} [customer name])
or
FirstSortedValue([customer Name] ,Amount)
or
aggr(FirstSortedValue([customer Name] ,Amount), Region,Territory)
Try like this
Min(Aggr(Sum({$<cusomer={'Worst cutomer'}>}Amount), Region,Territory,CustomerName).
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
You can try this:
only({1<Amount={'<=min(Amount)'}>} [customer name])
or
FirstSortedValue([customer Name] ,Amount)
or
aggr(FirstSortedValue([customer Name] ,Amount), Region,Territory)