Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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