Forum Discussion

fz1's avatar
fz1
Frequent Visitor
2 years ago
Solved

How to do nested sorting in a stacked column chart

Hello,  I am trying to do nested sorting in a stacked column chart and would appreciate any guidance on how to do it. This is my notional data:   This is what my stacked column chart (of num...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi fz1 

     

    You need to create two order tables.

     

     

    Merge each of the two order tables with the original data table.

     

     

    Expand the merged table, keeping the sort column.

     

     

    Click Close&Apply.

     

    Sort the Company and Model columns according to the following actions.

     

     

    Result:

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

qqqqqwwwweeerrr's avatar
qqqqqwwwweeerrr
Solution Sage
2 years ago

Hi fz1 

 

I am not sure with your current configuration it is possible to custom sort. But i tried to work around if it makes sense you can use that. Here is my Approach 

Step 1: Create Custom column based on sorting order 
Step2: use this confriguration:

And i have sorted this with new created custom sort column

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more interesting solution here: www.youtube.com/@Howtosolveprobem

Regards