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:
after i left only sub-sum part, i got results by players and seasons:
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?
Please any help?