Rank/ Aggr for Pivot table to get top 5

[rdsuperlike]

I want Top 5 fruits for 2016 and 2017 to be listed in the uploaded qvw.  If Top 5 of both year is not possible then I want top 5 fruits by 2017

I tried using dimensions limit by making it straight table. But then when i try to move the Fiscal year to the top column by moving blue arrow I cant. So I used pivot table, but in pivot table the dimension limits go away.

I think I need to use aggr function with rank function, but not sure how.

Can someone help me here?

Thanks once again

[sunny_talwar]

Could be a version related issue. What version of  QV you are using?

[rdsuperlike]

11.00.11282.0 SR1 64-bit Edition

[sunny_talwar]

Wow, you are still using SR1? Can you update to a more recent version of QV may be?

[rdsuperlike]

OMG..u are right...i just tested this one someone else's laptop who has later version and looked good there....how do you upgrade? or rather will check with IT team at my company

Thanks a lot

[sunny_talwar]

You can download from here:

Download Free Data Visualization Development Platform