Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Some question about aggr() function

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.

1 Reply
swuehl
MVP
MVP

Maybe like

=FirstSortedValue(DISTINCT

      Aggr(User_Name ,User_Name,Package_name),

          Aggr(sum(Spend),User_Name,Package_name)

)