top 10 sales in textbox

[paulwalker]

Hi Community,

I have a straight table showing top 10 records, using Dimension Limits.

Expression:

Sum({<Customer={'Boleros', 'Bond Ltd', 'Boombastic'}>}LineSalesAmount)
+
Sum(UnitPrice)

My requirement, User want to show in top records in textbox.

I have tried but i didn't get exact value, which I have in Straight table.

Thanks in Advance!

[MohammedMustaq · Accepted solution]

Try these

='Top 10 - ' & concat( aggr(if(rank(Sum({<Customer={'Boleros', 'Bond Ltd', 'Boombastic'}>}LineSalesAmount)
+
Sum(UnitPrice)) <= 10, ProductName), ProductName),chr(10), aggr(rank( Sum({<Customer={'Boleros', 'Bond Ltd', 'Boombastic'}>}LineSalesAmount)
+
Sum(UnitPrice) ), ProductName ))

Regards

Mustaq