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.