Multiple grouping of data

[Kawaljeet_Singh]

Hi All, 

I'm performing analysis using three fields:-

Country/ProductName/SalesAmount

Here I'm trying to group data in a form that I could get the highest sold product name with it's sales amount for each country.

For help, I'm attaching small data set in qvd form.

[abhijitnalekar · Accepted solution]

Hi @Kawaljeet_Singh ,

Please use below expression

=aggr(if(rank(sum(salesamount_))=1,productname_),country_,productname_)

to get desire output