Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a table which list all company sales for last year .
I need only display top 5 customer , it is possible to do it in QS ?
Now it display all.
Paul
Try this:
Sum({<year={2016}, COMPANY = {"=Rank(Sum({<year = {2016}>} sales)) < 6"}>} sales)
my QVF
Try this:
Sum({<year={2016}, COMPANY = {"=Rank(Sum({<year = {2016}>} sales)) < 6"}>} sales)
Hi All
Thank you both sharing. Sunny approach is very good , because i just need to display top 5 company. Where Alan way is more simple , but then it give the last row as a summation of all other row. This approach also have it advantages , as it will display total amount of the top 6 till the rest customer customer sales. Any way i just notice that this version have this setting , remember ver 1 does not have this,
Paul