Dynamic Top 10 list

[Former Member]

How can I create a dynamically changing top 10 list to chart in Xcelsius 5.0?

For example, we have 30 accounts in one month and we want to create a top 10 list of the accounts for that certain month. Then in the next month we gained 5 accounts and we want to update the list accordingly. In Xcelsius, it seems that when you are populating data, it has to be a set amount and the range will not change if new values are added to it. I understand that if it was a set number of accounts, then I could easily create a top 10, but with accounts constantly being added and removed, I am unable to figure it out. Can anyone offer any suggestions?

[Former Member]

Thanks.

Edited by: TonyM14 on Jun 30, 2011 5:01 AM

[Former Member]

TonyM14,

For dynamically changing lists you should pull a query(for the list) via QAAWS OR a webi report which updates regularly, through Live office connection. Also when trying to bind ranges for the dropdown filter limit it to some 50 rows(though u have initially 10 values to populate) so that the additions are considered.

Thanks,

Karthik

[Former Member]

This post shows how to get a top 10 result via QaaWS, Live Office, and BI Services: http://blog.davidg.com.au/2011/04/live-office-vs-qaaws-vs-bi-services.html

Are you getting your data externally?

If you must do the ranking in Excel, then use the rank function in a column to the left of the data. Then, in another area of the spreadsheet, have a grid with 1,2,3,4,5,6,7,8,9,10 in one column, then a lookup in the next column to pick the data from your source data based on the rank.

Or import the data in descending order and simply map your chart to the first 10 records.

Hope that helps.