Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Custom Sort - Percentage Ranges

Hi,

I am trying to custom sort an axis that lists percentage ranges but having trouble even after reading the number of articles on this. See Image below. I even tried to create a table to then order these. Help please!!

Need Help
  • RolandsP's avatar
    RolandsP
    8 years ago

    You need to create a relationship between your data table and new table where you created indexes using key Compa Ratio Ranges.

8 Replies

  • RolandsP's avatar
    RolandsP
    Resolver IV
    8 years ago

    You need to add Index column in the new table. And have something like this:

     

    Index   Value

    1          <80%

    2          80-89%

    3          90-99%

    etc.

     

    And then sort Value field by Index field. Then it should work.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks RolandsP! Any idea what I do next after I have added the index to then sort my graph in the same order?

       

      Thanks heaps in advance :)

      • RolandsP's avatar
        RolandsP
        Resolver IV
        8 years ago

        Please select Value field form Field list and then find Sort by Column button on Ribbon. You press that button and you will be able to select that Value field is sorted by Index field.