The solution is to use a combination of the Aggr and Rank functions in the dimension, see the attached which is your original file with the extra pivot table solution.
Pivot Table Top 5 Solution.qvw 118.4 K
Greetings to you,
I have got a problem with license,
When I run your Pivot Table Top 5.qvm file, I see this message :
The file was created by a licensed QlikView user and since you are using a QlikView Personal Edition you may not open this file.
Could i possibly ask you to tell me, what shall i do?