Straight table Top2 show

[krmvacar]

Hi , 

I have a flat table in qliksense as below. I am calculating the rate based on package number and country.What I want here is to show the 2 countries with the highest rates based on a package number. How can I do this?

Dimesion1= [Packege Number]

Dimension2=Category

Dimension3=Country

Measure=sum(ERFMG)/sum(total<MATNR,MATNR_SIPNO,[Packege Number]> ERFMG)

I want to result.

Packege Number Category Country-Top1 Ratio %-Top1 Country-Top2 Ratio %-Top2

0010936761        Primer      BAE                64,1%            Hindistan                   35,9%

0009736567        Primer     Kazakistan      68,6%            Malezya                      18,7%

Thank you so much.

Best Regards

[Clement15]

Hello,

Do you have a fake data set you could provide us with?

[Anil_Babu_Samineni]

there are certain ways that we have, example you can try like this

Firstsortedvalue(Category, -Max(Aggr(sum(ERFMG)/sum(total<MATNR,MATNR_SIPNO,[Packege Number]> ERFMG), Category)), 1)