9 Replies Latest reply on May 15, 2012 10:46 AM by Mel Stephenson

    Calculated or Automated Nested Sorting?

    Mel Stephenson

      In the workbook below I am using Steve Wexler's / Joe Mako's approach to Likert Scales with hundreds of topics rather than just a few. My difficulty is the sorting. As in Steve's original, I would like the topics to be sorted by their average score. If you set the view to show just one case then from the right hand side of the view (which shows the value for the average score for each topic in turn) you can see that the sorting is working fine. However if you choose to display more than one case then the sorting breaks down - the right hand side of the dual axis allows you quickly to spot the average score values which are out of sequence. Can anyone tell me the error in this worksheet, please?