Custom Sort - Percentage Ranges

[Anonymous]

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!!

[RolandsP]

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]

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]

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.

[Anonymous]

hmm not quiet what I am after.

I now need to sort the below graph in the same order as the index - how do I link the additional query to my raw data?

[RolandsP · Accepted solution]

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

[Anonymous]

Figured it out. Thank you!

[RolandsP]

Cheers!

[Anonymous]

I have done that and then sorted by index but still no luck.

Any other tips or tricks?

Thanks again @RolandsP