Skip to Content
0
Former Member
Feb 16, 2010 at 07:22 PM

How to get Top 10 Products out of 1000 rows of data

26 Views

I have a table with 1000 rows for the entire year. I have a requirement to find Top 10 Products ( top 10 ranks) per revenue per region.

When I bring all 100 rows to excel , how do I find the Top 10 products based on revenue? . Since Xcelsius cannot do any sorting to find the Top 10 what is best solution ?

I know Centigon Solutions provide a DrillFilter Addon, , bit would like to achieve this with the existing Xcelsius product.

Any recommendations?

Thanks

Pushpa