8 Replies Latest reply on Feb 17, 2016 10:57 PM by serfm

    How i can sort sub summary results based on calculating field?

    serfm

      Hi all,

      I'm using Filemaker 14 for basketball team stats.

      Could anyone help how i can sort sub summary results based on calculating field.

      I have fields: PlayerID, FG (Field Goals), FGA (FG attempts) and FG%.

      I use FG% as calculation field in sub summary, which is: GetSummary ( TotalFG ; PlayerID )/GetSummary ( TotalFGA ; PlayerID ).

      I put stats for each player after each games.

      I need to get a report who is the best shooter (based on % after N games (or after season))

      This table already shows sub summary results

      Screen Shot 2016-02-16 at 5.09.02 PM.png

      and I can not sort it by FG% descending as this field is not active when i'm trying to reorder based on summary field.

       

      Could any help with this please?