sorting issue in a straight chart with multiple dimensions

[#1]

Hello,

I have a straight chart with four dimensions (1,2,3,4) and one expression (Amt). The goal is to sort the rows by Amt in descending order. I tried using sort by expression using various formulas and it works in desktop and IE plugin. However any solutions that worked in desktop or IE plugin don't work in Ajax. The goal is to get it to work in Ajax.

Any help is appreciated.

Thanks

[Anonymous]

Pardon me if i have got it wrong, But, I dont see a reason as to why the sort by expression would not work on ajax. try using a set in the expression for sorting like below.

SUM({1} Sales)

hope this helps.

Regards,
Aadil

[#3]

Sorting by expression works just fine in desktop and IE plugin but not in Ajax. I don't see a reason why it shouldn't work either. I tried your suggestion as well before posting this problem but it doesn't solve the issue.

Thanks,

Matt

[pgriffiths]

I came across the same issue and could not find the answer in the forms.

After lots of testing, I found I could get this to work in Ajax(IE) with a new straight table and moving across all the dimensions and expressions one at a time and testing the sort by expression after each change. This took most the day as there was a lot in the chart.

In the end, I went back to the original straight table to try and find out why the new one worked with all the dimensions and expressions copied across. I found the only difference was I had two expressions in the old straight table that were not enabled. I deleted these from the original straight table and made sure the Expression I wanted to sort by was at the top of the Sort tab and the original straight table was then sorted correctly by expression in Ajax(IE).

It would seem in my case at least, the expressions that were not enabled broke the Sort order in Ajax, but not in Desktop.

Everything is now working fine in Ajax.

Hope this helps someone with the same problem.

Happy days.

[avinashelite]

have you added the expression in sort tab> expression ?? and have promoted the sort option to the top ?