Top 5 sales in a table box

[Kohli]

I have table with

Product, Sales, Profit

Can you please suggest me how i get top 5 Profit in table box

[ramasaisaksoft · Accepted solution]

Hi Kohli,

(Product) as Dimension

Sum( Sales) : Measure

Sort Type:  Condition Sum( Sales) & Ascending order

Dimension Limit: 5

else

=Sum({<Product={"=Rank(Sum(Sales))<=10"} >}Sales)

[Kohli]

Thank You Ramasai

[Kohli]

It's working for different products. But same product have multiple top sales it's not working.

EX:

Product, Sales

Box, 3000

Pencil, 500

Box, 3600

Pen, 2500

Blender, 100

Chocolate,  2000

I want output like

Box, 3600

Box, 3000

Pen, 2500

Chocolate, 200

Pencil, 500,

But Iam getting

Box, 3600

Box, 3000

Pen, 2500

Chocolate, 200

Blender, 100

Pencil, 500,