how to show top 3 sales product names under the category in straight table?

[#1]

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.

[#2]

Hi,

Try this

Aggr(Max(Sales,3),Product)

[#3]

Hi Rakesh Goud

Thank you for your quick response. the formula you have provided is not satisfying my conditions.[your not using any category]

[Anonymous]

This will work:

if(aggr(rank(sum(Sales)),Product) <= 3 ,Product)

[#5]

Try this

if(aggr(rank(sum(Sales)),Product) <= 3 ,Category)

[rustyfishbones]

[#7]

Try this

if(aggr(rank(sum(Sales)),Product) <= 3 ,Category)

[#8]

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