AnsweredAssumed Answered

Sort on second field after Sub-Summary sort

Question asked by Fred_1 on Jun 11, 2015
Latest reply on Jun 11, 2015 by 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!

 

 

Outcomes