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

[stigchel]

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

[er_mohit]

For this

under sort sort tab for particular chart object

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

hope it helps

[Anonymous]

Hi,

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

[#5]

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

[#6]

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

[stigchel]

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

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

[#8]

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

[tresesco]

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

[#10]

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