8 Replies Latest reply: Feb 23, 2016 10:27 AM by kawtar elaloui RSS

    Sort Stacked Chart by Y and 2nd Dimension

    Pat Buchanan

      I've been asked to create a stacked chart to sort by Grand Total and then in each bar to sort the values from High to Low.  When it displays all of the choices it doesn't sort High to Low for each bar but if I click on just one Location then it sorts properly, just not when all data is displayed.  I saw some examples show aggr but when I tried that with my data still no luck...  I've attached a sample file.

      All Data-Not Sorted Properly.JPG

      Notice Location 7 along with others are not sorted High to Low

       

      Filter 1 Location-Sorts Properly.JPG

      But if I click just on Location 7 then it does sort the data properly...