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
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?