Bottom N set for Bottom 5, but 6 records show.

[m_roussakis]

As title states, I have a Bottom 5 list based on lowest percentages. I set it to bottom 5, however 6 records appear. There are no ties in the percentages. Anyone have any ideas how to fix this? Thanks. 

[m_roussakis]

thanks. I was filtering on the wrong value! Fixed that and now 5 show. 

[PhilipTreacy · Accepted solution]

Hi @m_roussakis 

For each Division, what are the corresponding values for Total % Opportunities ta ....... - that is what you are filtering on for the bottom 5 items.  You sure there aren't any ties?

Regards

Phil