Yes, the rank() is bringing them back in, there is a note to the Help topic for rank function:
Suppression of zero values is automatically disabled when these functions are used. NULL values are disregarded.
Hm, I remember vaguely that I fought with this some time ago, I just don't get if and how I handled this.
Could you upload a small sample file? And on which version are you?
try the expression
if([AvB %]=0,0,rank([AvB %])) and then force the sort on numerical order on this expression.
Also check in the Dimension, Suppress when value is null and in the Presentation, Suppress Missing and Suppress Zero Values checked.
This will default the bad results to rank 0. hope this helps.
The proposed method will only give the bad results a rank of 0 - not hide them.
The table consists 3 expressions which use set analysis to hide unwanted rows, whick are revealed when the rank og rowno functions are used.
Basically I just want to have a line number in the table, so the user easyier can keep track of progress.