Keeping the top 50 records

SteveP · January 28, 2011 5:32AM

I am importing 14,000 records, and each record contains a category, a product number, and a description. The list is pre-sorted into descending sales value within category, but the actual sales value is not included.

If I select a single category, I might see 100 or 1000 records, depending on the category, but how can I just see the top 50 records for that category? In effect, I want to limit the view to a maximum of 50 records regardless of which category is selected.

Any ideas?

Thanks

steve · January 28, 2011 7:08AM

See http://www.visokio.com/kb/useful-formulae

steve · January 28, 2011 7:09AM

Something like this...
IF(AND([B] != null, RANK([B], [B], SUBSET([Category]))<=50), "Top 50", null)

SteveP · January 28, 2011 7:22AM

Not too sure what column B is here - I only have category, product number, description, so nothing to actually rank the rows on, apart from the order they have come in with.

steve · January 28, 2011 7:28AM

B is the column you rank by. If you don't have one, only the inherent ordering, there is probably another solution but it doesn't spring to mind. Simply add a new field "Order" with formula CURRENTROW, and use this instead of B.

SteveP · January 28, 2011 7:32AM

That sounds workable - thanks for the quick response.

Steve

Welcome!

Categories

Ideas Parade