Skip to Content
author's profile photo Former Member
Former Member

Dynamic Top 10 list

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2011 at 08:29 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 30, 2011 at 03:01 AM

    Thanks.

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.