1 Reply Latest reply on Dec 21, 2012 6:51 AM by philmodjunk

    Sort by Subsummary Field



      Sort by Subsummary Field


           I made a subsummary layout with layout parts. However I need to sort by that subsummary field that is a total of a calculation field. It won't let me sort by that subsummary field. How do I sort this and then rank it?

        • 1. Re: Sort by Subsummary Field

               Take another look at your Sort Records dialog box.

               Near the bottom is a check box: "Reorder based on summary field'

               This sorts your records twice, first to group them by what ever value groups them for your sub summary layout part and then this "reorder" option allows you to order the groups themselves.

               Please note that this option can produce significant delays when you are working with larger groups of numbers as this second sort is essentially a sort on an unindexed value (the sub totals).