Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
how to show top 3 sales product names under the category in straight table?
i got rank of products by using the formula =aggr(rank(sum(Sales)),Product)
now i want to show top 3 products in each category can any one help me to resolve it.
Hi,
Try this
Aggr(Max(Sales,3),Product)
Hi Rakesh Goud
Thank you for your quick response. the formula you have provided is not satisfying my conditions.[your not using any category]
This will work:
if(aggr(rank(sum(Sales)),Product) <= 3 ,Product)
Try this
if(aggr(rank(sum(Sales)),Product) <= 3 ,Category)
Try this
if(aggr(rank(sum(Sales)),Product) <= 3 ,Category)
I Need Like this
Category | Product | Sales |
Beverages | ||
Côte de Blaye | 46563.08 | |
Ipoh Coffee | 11069.9 | |
Lakkalikööri | 7883.1 | |
Confections | ||
Gumbär Gummibärchen | 11225.65 | |
Schoggi Schokolade | 10974 | |
Tarte au sucre | 20762.82 | |
Dairy Products | ||
Camembert Pierrot | 20652.28 | |
Gudbrandsdalsost | 14041.8 | |
Raclette Courdavault | 33616.55 | |
Grains/Cereals | ||
Gnocchi di nonna Alice | 32604 | |
Singaporean Hokkien Fried Mee | 5184.2 | |
Wimmers gute Semmelknödel | 7125.47 | |
Meat/Poultry | ||
Alice Mutton | 16580.85 | |
Perth Pasties | 12784.13 | |
Thüringer Rostbratwurst | 33109.51 | |
Produce | ||
Manjimup Dried Apples | 23550.02 | |
Rössle Sauerkraut | 12854.28 | |
Uncle Bob's Organic Dried Pears | 9186.3 | |
Seafood | ||
Boston Crab Meat | 9796.33 | |
Carnarvon Tigers | 15950 | |
Ikura | 8819.5 |