sorting in line chart

[#1]

I am using a line chart in which I have dimensions D1, D2 and an expression E.

I want to sort D2 using a logic other than 'E'. I tried to write that logic in the the sort tab but still the dimension is getting sorted on value of 'E'.

Any other way of sorting the expression?

[#2]

Here D1 is my primary dimension so I cannot promote D2 in dimension tab.