AnsweredAssumed Answered

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

Question asked by serfm on Feb 16, 2016
Latest reply on Feb 17, 2016 by 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?

Outcomes