Sort order is not working

[TomBond77]

Hi experts

Under "Sorting" I have expressed this sorting order:

match([Divisions_ST.Sort],
'Order Intake 3P',
'Order Backlog 3P',
'Net Sales',
'EBITDA',
'EBIT',
'EBIT in % of Net Sales',
'EBIT(R)',
'Cash Flow from Operations',
'Cash Flow from Investments',
'Free Cash Flow',
'Net Working Capital',
'Net Financial Position',
'Research & Development (self-financed)',
'Employees as per end of month')

As a result I get this:

Any ideas how to fix this?

[krishna20]

Under the Sorting, select expression and add your Dimension.

[TomBond77]

That is exactly I did. Not working.

[krishna20 · Accepted solution]

Solution 1: Try Max({1} Your_Dimension) if it not works ,

Solution 2: create an Inline table 

Load  * Inline [

Divisions_ST.Sort, %Dim_Sort

'Order Intake 3P',1
'Order Backlog 3P',2
'Net Sales',3
'EBITDA',4
'EBIT',5
'EBIT in % of Net Sales',6

];

Under the Sorting, select expression and add use %Dim_Sort in Ascending Order.

[TomBond77]

Thanks Krishna, Solution 1 is working!