I need only display top 5 customer , it is possible to do it in QS table ?

[paulyeo11]

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

[paulyeo11]

my QVF

[alan_richmond]

[sunny_talwar · Accepted solution]

Try this:

Sum({<year={2016}, COMPANY = {"=Rank(Sum({<year = {2016}>} sales)) < 6"}>} sales)

[paulyeo11]

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