Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am attempting to to display the customer with the minimum sales with set analysis and I am having trouble. So if I am using the KPI object and have 2 customers like Cust1 (sales = 80000) and Cust2 (sales = 90000) I want to have the KPI object display Cust1.
Any help would be appreciated. Thanks!
This may help
=only({$<Sales={$(=min(Sales))}>} Customer)
considering Sales as the field with total sales of customer and Customer as the name of the Customer
If two or more customers have the same Sales as the min(Sales), the only function will return a null
Eduardo
May be this:
=FirstSortedValue(Customer, sales)
or
=FirstSortedValue(Customer, Aggr(Sum(sales), Customer))
Definitely this is the answer , I've tried:
=FirstSortedValue(Customer, TotalSales)
what about this:
=aggr(min(sum(Sales)), Customer)