Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table with
Product, Sales, Profit
Can you please suggest me how i get top 5 Profit in table box
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)
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)
Thank You Ramasai
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,