2 Replies Latest reply on Nov 21, 2012 2:46 AM by Brian Near

    Sorting problem

    Brian Near

      I have what should be a simple worksheet.  There are no filters set, and the fields in the view are not in a hierarchy, group, set, etc.  The problem is, the sort isn't displaying correctly.

      Here's my sort criteria:

      Sort Order: Descending

      Sort By: Field ("Number of Records")  Aggregation: Sum (although count works exactly the same)

       

      The only thing I can think, is that there are duplicates in the "charged_region" field (notably "EAST")

       

      Can someone tell me why my data doesn't sort properly?

      SortIssue.jpg