Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a question confusing me for a long time.
if I write a scripts like this: min(Aggr(sum(Spend),User_Name,Package_name)), I can get the minimal Total Spend of each User for each Package. But what if I want to get the name and the package name , How can I do that??
thanks for the warm help.
Maybe like
=FirstSortedValue(DISTINCT
Aggr(User_Name ,User_Name,Package_name),
Aggr(sum(Spend),User_Name,Package_name)
)