12 Replies Latest reply: Jul 22, 2014 9:18 AM by Piet Hein van der Stigchel

how to order expressions

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??

• Re: how to order expressions

In the sort tab put a sort expression for the expression and use Aggr(sum([Qty]), YourDimensions)

• Re: how to order expressions

Hi,

In the sort tab put a sort expression for the expression and use Aggr(sum([Qty]), [Dimension])

• Re: how to order expressions

in the sort tab I've the list only of my dimensions though...I cannot the expressions too..

• Re: how to order expressions

For this

under sort sort tab for particular chart object

write sum([Qty]) for expression side and check on descending order

hope it helps

• Re: how to order expressions

I've tried what you guys suggested me, but it's not working...I'm pretty sure I might have done something wrong...can someone provide me the screen shot of how it should be done (or explain me step by step what to do)???

• Re: how to order expressions

Also include the first dimension Reggioni(?) in your Aggr expression, so

Aggr(Sum([Qty]), Dimension1,Dimension2.....)

• Re: how to order expressions

I think you're looking the wrong chart...the chart Name is "Num Ordini Cliente/Articolo"...

• Re: how to order expressions

?? 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.

• Re: how to order expressions

It is simpler than you think:

In the sort tab, take your expression column on top using 'Promote' button. Then select it->Numeric Value->Descending/Ascending (as you want).

• Re: Re: how to order expressions

I thought it was that simpler, but in the sort tab I DON'T HAVE MY EXPRESSIONS, I see only the dimensions..

• Re: how to order expressions

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.

• Re: how to order expressions

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