Rank Function

[leni_harishwara]

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

[tresesco]

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]

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