how to order expressions

[#1]

hi everyone. How can I order from the highest to the lowest value the expressions? I mean, for the dimensions you just on the folder Order and it's pretty easy. but what about expressions? For example I added the expression sum([Qty] and I would like the values to be in a decreasing order...is it possible??

[tresesco]

That means you are using pivot chart(which is not very sort friendly) rather than a straight table. Then try like this, copy the same expression here in sort tab like:

Note: Issue may (as I notice from your earlier screen shot) be because, you are selecting your second dimension and then using the expression. Select the first dimension in the sort tab and use the expression there. And you must note that this will actually sort the dimension values rather than expression values.

[richard]

Once again, using a straight table gives a greater advantage for seeing the data rthe way you want.

[stigchel]

?? I don't have the document, only your picture (Decreasing.jpg) to look at. There is but 1 graph Num Ordini Cliente/Articolo and Ragione is from the look of it your first dimension. The Aggr function in the sort expression should reflect ALL your dimensions over which the expresssion, with the values you want sorted, is calculated.