AnsweredAssumed Answered

Sub summary sorted first by other field

Question asked by jacobjz on Jan 24, 2016
Latest reply on Jan 24, 2016 by MaxEh

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)

Outcomes