Sort Order changes between Straight Table & Combo Chart

[#1]

See small example attached.  Notice I have the sort order on LineSalesAmount then Customer in the straight table.  However when I use the fast change to combo chart the sort order completely changes.  How do I make the sort order on the combo chart the same as the  straight table.  I need both chart types to be in the same sort order.

[pover]

Changing your object to a combo chart, go to Properties->Sort and enable the Y-value Sort and select 'Descending'.  If you change the table sort dynamically it won't change in the combo chart, but if you change the order of the table columns (eg. drag UnitsonOrder column so it appears before LineSalesAmount), you can get the combo chart to either do a descending sort of LineSalesAmount or UnitsonOrder.

Karl

[#3]

Hi Karl, Thanks but how do you sort on the Y value then on the dimension in a Line or Combo Chart.  For example using the QVW attached above. If I had several customers with the same $ Amount in Column 1 how do I sort on the Y value (descending) then on the Customer dimension (ascending) in a Line or Combo Chart.  I hope this is clear.

Melinda

[#4]

Attached is an example of the sort order changing when I go from a straight table to either a Line or Combo Chart.  As you can see the straight table is order based on the Perct_change (descending) and Customer column.  However, when you switch to a line chart (use Fast Change button)  the sort order is not in the same order as the straight table.  How can I get the straight table and line chart to match sort order?

[pover · Accepted solution]

The easiest way and if the user doesn't change the order in the table would be to sort by the expression and then by text.  I've included an updated version of your file.

Karl

[mdmukramali]

Dear,

sort the Y-axis values in the Descending order. then sum(LineSalesAmount) will come in order same as order in straight table..

[#7]

Thank you Karl, this is pretty much what I needed.