I am doing top 10 query that brings in more than 10 records because there is a tie. I have the resulting table sorted by # of instances of each record but still have 20+ records. I have created a variable to count and applied a top 10 ranking in the report based on that variable. That limits it to 10 records but not the first 10 as sorted. I need the highest instances first. It seems to remove the sort before it gives me my 10 records. Is there something I’m missing or something more that I can do. The field with the numeric value is not in my list of fields to rank by.
lcihon40 (BOB member since 2014-12-26)
(BOB member since 2005-01-06)