This is a slight variation to the the post by Nigel West (http://community.qlik.com/forums/p/21096/80926.aspx#80926).
I have a straight table in which i would like to display the top 10 Stock items by Value. Currently i've set up the straight table to show Stock Items by Total Value in descending order and set the max visible number to 10.
My problems are:
1. I would like to see a sum of the top 10 in both expression columns. Currently I can see a total of ALL and a total of ALL that are not displayed (Others), I want to see what IS displayed.
2. I would like to add a row number to my chart, but when i use rowno(total), i experience the same problem as federico as seen here (http://community.qlik.com/forums/p/18012/70446.aspx#70446)