give order some pivot table

[#1]

for example , if I have  a pivot table and I need order by numeric expression
but right to left.

how can I do ?

best regards dear experts.

I send  an example

[alexandros17]

The best way you have to sort is ordering by Y-dimension ...

All other ways are unuseful ...

[#3]

but when I do that , only uses the name of the expression and only order by alphabetic way and I need an order by the value of the expression and it is numeric.

exists some way to do that?

[alexandros17]

It orders values of the first expression ascending or descending.

Try to use sorting by expression ....

[stevedark]

Sometimes getting sort orders in Pivot tables to do what you want is not straight forward, particularly when you have nested dimensions.  If you have a single dimension on the left and another on the top it should be possible to get it to sort right.

On the Sort criteria for the Dimension you have along the top tick the check box for Expression and copy and paste the expression you have for the Pivot into the expression box.  You can then chose Ascending or Descending from the drop down box.

Hope that helps.

Steve

[#6]

ok , I got it , just made a sub consult with resident  command ,grouping  by the field to I wish sort then I use that you said.

tanks a lot.experts