AnsweredAssumed Answered

Sort by inactive Summary Field?

Question asked by serfm on Jun 29, 2018
Latest reply on Jun 29, 2018 by serfm

Good day!

I have yearly stats for my basketball team players for many years. Each season has league games and play-off parts (play-offs not every year). I need to find out who is the best scorer (rebounder, assists etc) over all, counting the whole season. After doing report where i summarized data by players and seasons i got this result:

Screen Shot 2018-06-29 at 10.32.37 AM.png

after i left only sub-sum part, i got results by players and seasons:

Screen Shot 2018-06-29 at 10.39.28 AM.png

Now i sorted it by _kf_player_code and _kf_season. I reordered based on summery field total_pts (which is summary field for "pts"). It's still showing the best results for one player, then best results for next players etc. How i can sort it by pts only if Tot_Pts is inactive and i cannot use it for sorting?

Screen Shot 2018-06-29 at 10.46.16 AM.png

Please any help?

Outcomes