Rank Function

leni_harishwara — Thu, 13 Sep 2018 10:26:10 GMT

Hi All,

I would like to get the Rank of a product from the list of products based on different conditions like Area, Country.

So in my source I have Area, Country, Product and so on.

I would like to get the Rank of a Product 'A' from the list of products in each country and area.

So as you could see from the above screenshot I have highlighted the Product. So in a Area and in a country the Rank of the product is 36 and 27.

I need the same detail in a pivot table but not for all products only that particular product.

Area Country Rank of the Product Zrnvtl

ATSK&G KWCVDSWM 36

JETKB JTCGNPHX 27

Something like this.

Can anyone please help me to get this sorted out?

Regards,

Leni Harishwaran

Re: Rank Function

tresB — Thu, 13 Sep 2018 10:44:15 GMT

Do you want to select a certain product and check it's rank? Or, it's always that specific product? Could you share your sample qwv?

leni_harishwara — Thu, 13 Sep 2018 10:47:00 GMT

It is always the specific product. Sorry now I don't have a sample file to share I try to create a sample which satisfy my requirement and share.

Regards,

Leni