Rank function in Query Join

[Bonediggler]

Experts -

I am trying to the apply the Rank()function to the result set of a query join.  This is not working - the values returned by Rank() appear to be applied to the data before the join somehow.

In any case, how would I get the Rank() function to work in this case?

Thanks in advance for your help!

[Francis aka khayman]

set it to after auto-aggregation...

more here:

http://cognosm.fm3online.com/relational/top-5-report/