Skip to Content

how to do ranking for top 10 by using excel data in dashboards

Hello everyone,

how to do ranking for top 10 by using excel data in dashboards..?? how we can corelate dynamic visibilty with the ranking option..?

Regards,

winod

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2013 at 10:08 AM

    Hi Vinodh ,

    RANK functionality is not directly achievable in Xcelsius.

    You can try using combination of RANK, MATCH and INDEX function in the Excel .

    Thanks,

    Arun US

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 18, 2013 at 11:10 AM

    Hi Vinodh,

    You can find multiple ways to implement ranking in excel side using different formula. PFB link to see one of such logics.

    http://ryangoodman.net/blog/index.php/2006/12/01/dynamic-ranking-logic/

    But its not advised to implement ranking logic in excel side which will affect the performance of your dashboard. What type of data connection you are using to connect to backend. If its live office or BIWS, you can implement top N logic in webi report and pass the result. If its BICS connection, implement it in BEx query. Let us know what type of connection you are using.

    I am not clear about your second question reg dynamic visibility and ranking. Could you please explain your exact requirement?


    Regards,

    Nikhil Joy

    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.