Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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