3 Replies Latest reply on Jan 24, 2016 1:59 PM by MaxEh

    Sub summary sorted first by other field

    jacobjz

      I have a table with many fields. The most important of which is a SortOrder field which simply contains a number so that reports are sorted accordingly.

       

      I also have another description field. In a report, I'd like to use the description as a sub summary to group together like records, BUT it should never override the sort order field. I'm not sure how to do this so that my sort order is always preserved? Thanks for your help!

       

      Here's what I'd like my report to look like:

       

      Description Alpha

      Sort 1

      Sort 2

      Sort 4

      Description Beta

      Sort 4

      Sort 9

      Description Alpha

      Sort 11

      Sort 13

       

      (Note how a category repeats rather than mess up my sort order)