cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic Top 10 list

Former Member
0 Kudos
210

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?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks.

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

Former Member
0 Kudos

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
0 Kudos

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.