top selling products

[capriconuser]

hi

i have several data like this

Name of product amount

product1 1200

product2 1500

product3 1200

product4 1400

product5 1400

product6 1500

now here top 2 products name in textbox like this

product2 , product 6

means i want to get top selling products name  in textbox

how i do this

[thevingo]

try

=Concat(firstsortedValue([Name of Product],-aggr(sum(TOTAL amount),[Name of Product])),',')

[capriconuser]

kindly check updated attachements in question i use your solution but this shows an error

nested aggregation is not allowed..

and secondly i use this but this shows only amount 1500 ... products is not display

='Top Salesperson: '  & firstsortedvalue( products, -Aggr(sum(amount),products)) & ', Sales: ' & num(max(Aggr(sum(amount),products)))

[chinnuchinni]

try this:

='Top Product :     '&FirstSortedValue([Name of product],-Aggr(amount,amount)) & '     Sales :  '&FirstSortedValue(amount,-Aggr(amount,amount))

[capriconuser]

this shows only product 2 where i want also product 6 because there is two names associated with 1500 ..

so i want product 2 and product 6.

[chinnuchinni · Accepted solution]

= concat( aggr(if(rank(sum(amount)) <= 1, [Name of product]), [Name of product]),

chr(10),

  aggr(rank( sum(amount) ), [Name of product] )

)