Custom Sort Logic for a drill down hierarchy

[Anonymous]

Hello,

I need to add a custom sort logic for a two-level drill-down hierarchy. Basically, the structure is similar to this
Category levels

|- IT 1 - Low

            - Medium

             -High

|- IT 2 - Low

            - Medium

             -High

|- IT 3 - Low

            - Medium

             -High

We have a bar chart which we drill down in hierarchy mode and we have turned off the concatenate option for x axis to have this nice view. 

Here the pink crossed out data labels are category level 1 data and blue ones are level 2 data. 

I wish to arrange it like LOW,MEDIUM,HIGH . If we sort by x axis, it can only sort alphabatically. So I created a lookup table which has a rank value like this

label_key	Label Value	Rank
it1_low	Low	1
it1_med	Medium	2
it1_high	High	3
it2_low	Low	4
it2_med	Medium	5
it2_high	High	6
it3_low	Low	7
it3_med	Medium	8
it3_high	High	9

I followed this article,  but it doesn't seem to work. Rest all options that I explored are not for drilled down mode. They work for single value bar graph.

The issue we have is that the entries are repeated, hence we cannot sort the Label Value column based on rank.

Really appreciate any thoughts anyone has to solve this or even suggest a new approach to do this.

Thanks,

Sneha 

[Anonymous]

Thank you for your response. Yes, ideally that should work but it doesn't in my report. So as a work around I have added number prefixes for the field name, which is not neat but it works.

[amitchandak]

@Anonymous , Only have three values 1,2,3 low medium, and High

Then mark that as the sort column

Have two-column Axis, Sort on them expand-> Concatenate Label off

refer

Concatenate Label off : https://youtu.be/QgI0vIGIOOk