Pivot Table Sorting for multiple dimension

[md_talib]

Hi Qlik family,

I have three dimension field (Company, H1 & H2) .I am trying to sort dimension in pivot table as per my dimension mapping num. 

When I go for the company and H1 it is showing correct sorting order but for h2 it is not correct i have tried everything but its not working.

for e.g

Rank(min(H2_NUM))

Dual(H2_DESC, H2_NUM)

Note: sorting is based on the mapping number not on measure.