Selection Step returning wrong results

Question

I have 4 columns in a report:

Agent ID

Dist ID

Activations

Rank

*note - the above 'Rank' column used the RANK function: Rank(Activations)

In my report, I only want to show the Agents with the top 25 in 'Activations'.

I set up a selection step on Agent ID to keep only members of Agent ID where Rank <= 25

This seems to work pretty well EXCEPT it returns one row where RANK is 86 and Sales = 0

I cannot seem to get the selection step to not return that last row where Sale = 0.

Any thoughts on why this member with a rank of 86 would be displaying?

Message was edited by: CArnold40
Corrected typo -- changed 'Rank>=25' to correctly show 'Rank<=25'

CArnold40 · Answer

Yes, thank you. I just went ahead & did what you were suggesting & created a filter in the criteria. It worked.

I'm still left wondering why the 'Selection Step' method was returning that one 'rank 86' row. It just makes no sense to me.

Oh well...I may be left to always wonder...but at least my report is built!

Thanks again.

Thomas Dodds · Answer

Your Rank() ... are you ranking BY anything?  going to try to recreate something similar ...

On second thought if you only want the top 25 Ranked Agent IDs (independent of Dist ID) then apply a filter in Criteria tab to the rank(activations) to be less than or equal to 25 ...