Straight table mutiple dimension sort by expression

[wenkew186]

Hi guys,

I have a problem need your help.

Question1:    A straight table, 3 dimension(Dim1,Dim2,Dim3) and 3 expression (Exp1,Exp2,Exp3), Exp1 has positive and negative. so I want sort by FABS(Exp1) on Dim1. is this possible?

Question2:   If it's possible, another question is the D1 have an irregular value '?',it is necessary and regular value is ID.

                    I think the "?" will impact sort result.   how to solve it?

[JonnyPoole]

Yup.  On the sort tab, ensure 'Dim1' is listed first and sort it by expression:

try the first and if not, the second

Sum( Fabs(Exp1))

or

aggr( sum(Fabs(Exp1)) , Dim1 )