4 Replies Latest reply on Jun 11, 2015 4:43 PM by Fred_1

    Sort on second field after Sub-Summary sort

    Fred_1

      Title

      Sort on second field after Sub-Summary sort

      Post

      Hi.  I'm kind of new to reports in FileMaker and have a hit a simple wall.  I have a single field called NAMES.  The field has names as text.  I created a subsummary field called TOTAL to run a count when sorted by NAME.  And this works fine.  I then am able to sort by the values in the subsummary field and I get this:

      TOTAL    NAMES

      10         Henry

      10         Adams

      10         Cross

      5           Jones

      4          Smith

      1          Henricks

      The TOAL amounts sorts fine, but how do I get the alpha of the NAMES to also sort under the value 10 to get this:

       

      TOTAL    NAMES

      10         Adams

      10         Cross

      10         Henry

      5           Jones

      4          Smith

      1          Henricks

       

      Many thanks!