Ranking ?

[QlikTonic]

Hi everybody,

I don't find the way to do something probably easy for you !

I have product categories and sales for 2 years and comparison. I need to add in my pivot table 2 informations :

1- the best client name

2 -  the number of product bought by the client

i tried something with rank but no success for me

Someone could help me please ?

Thanks a lot

Chris

[sunny_talwar]

May be like this

Score

Max(Aggr(Sum(Score), Product, Client)

Best Client

FirstSortedValue(Client, -Aggr(Sum(Score), Product, Client))

[QlikTonic]

Hi,

This is just perfect, thanks a lot and have a nice day

Chris