applying a record restriction in a view after a grouping

applying a record restriction in a view after a grouping

hello-
i'm working on a simple team status update tool, where a member of a team can update the status of thier team (open/closed), and others can view the status of the teams (4 teams total). I want to display this all in one view, and I am having problems making it work- here's what I want to do-

list 4 teams in list view, grouped by team, sorted by time of last update, but show the last 3 updates maximum per team:

I know I can limit the view to all records, but if a particular team's status changes more frequently than others, I may have 10 updates from 1 team, before another team makes any changes: here is my script, any suggestions?


list "SLHS admitting team status View"
{
show all rows from SLHS_admitting_team_status_Form
(
Team
Modified_Time as "Last Modified Time"
status_selector as "Team Status"
)
filters
(
Modified_Time
Team
status_selector
)
group by
(
Team ascending
)
options
(
display rows = 10
)
}