Skip to Content

Rank is same,then based on growth

Hi experts,

palnt score rank GROWTH

01 1000 1 12

02 500 2 15

03 500 2 20

IF IT IS SAME RANK THAT TIME which plant is high Growth percentage that should come first,,

above example

plant 02,03 are same rank then i want like this

palnt score rank GROWTH

01 1000 1 12

03 500 2 20

02 500 2 15

How?.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 09:39 AM

    Hi Ganapathy,

    It looks simple but it is working for me. Test this once.

    Remove all sorts on the table and apply the first Ascending sort on Rank values then apply the second Descending sort on Growth values. You will get the required output.

    Hope this helps.

    Sampath

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 10:54 AM

    Hi Ganapathy,

    Try this work around Firstly convert Growth into detailed object and use Add ranking

    in that specify top or bottom based on your selection criteria and tick "ranked by" and in the drop down select growth.(by default it picks up only dimension and detailed only) measures it would not consider so convert your growth into detailed object and apply on it.

    pls try and let me know

    hope this helps

    Regards,

    sundar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 11:08 AM

    Hi Ganapathy,

    I have tested without any ranking or sort and I have obtained the following result:

    If you are not obtaining the same thing after removing all sorts and ranking, please try adding a ranking on "Score" and sort the growth ascending.

    Sorting:

    Best regards,

    Wafa


    ranking.jpg (31.1 kB)
    ranking1.jpg (96.6 kB)
    ranking2.jpg (85.6 kB)
    sort.jpg (103.2 kB)
    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.