Sort by Expression

[alec1982]

Hi,

I have a bar chart with one dimension and 5 expressions.

I am trying to sort by Y Descending but it is not working....

My dimension is AA

and my Expressions are Sum(Q1), Sum(Q2), Sum(Q3), Sum(Q4), Sum(Q5)

Anybody has suggestions.

Thanks,

Alec,

[MayilVahanan]

Hi

     Can you post a sample file?

[ericcosmai]

Hi Alec.

In this case, as you have 5 expressions, when you chose to sort by the Y Descending, you are saying to the chart to sort by the first expression it finds on your list of expression. Follow an aplication like example.

Hope it helps.

Regards.

[alec1982]

Hi,

Thanks for the replay.

The bars are stacked. so Anybody knows how can sort by all expressios together

Thxs,

[swuehl]

Try a sort by expression with expression

=rangesum( Sum(Q1), Sum(Q2), Sum(Q3), Sum(Q4), Sum(Q5) )

[ToniKautto]

I dont really understand the question. Are you saying that you want to sort your dimension by the total sum of all expressions?

Is this the sorting expression you are looking for?

aggr( Sum(Q1)+Sum(Q2)+Sum(Q3)+Sum(Q4)+Sum(Q5) , AA )

Or maybe this could be an option?

aggr( Sum(Q1 + Q2 + Q3 + Q4 + Q5) , AA )

[alec1982]

Hi,

Using this method i am getting red line under AA

Thanks,