You'd need some filtered portals that filter by team and ScoreOrigin and a non running summary field to put in those portals to get your columns of data for a given match record.
On the other hand, if you based your layout on the scoring table, the correct sorting and use of sub summary layout parts could be set up more simply to produce a report of this format:
Team B = 1
Free Kick -
Team B =2
General Play -
Team B =3
Thanks for the reply Phil. I have been able to create a report which as you suggested is a more simple exercise however the chart is the alternative that allows for a quick visual that could occur in a small break during a game.
I am not sure I understand your solution using filtered portals - am I right in assuming that there is more than one portal(one for each combination of team and origin type)? I think I understand that part but i am lost how you can then link the chart to grab that information.
Thanks for any further assistance you can provide.
I can do this in excel and get a graph like this one - I just dont know whether a.) i can do this in FM and if so b.)how
Ok, I had wondered at your reference to "chart" in your first post. My description of using portals would be to create a tabular chart of rows and columns of data, not a Filemaker Chart object.
Charts can be set up to chart sub totals of groups of data produced by a specific sort, but they have a limitation not encountered in a summary report: the method only works for a sort order based on a single field and the sort order you need here is from data in several fields.
To get the chart to work, you'll need to construct a calculation field that combines the Team ID with the score origin in such a way that sorting on this single field produces the same groups as I showed for the summary report when sorting by both team and score origin.
Thanks Phil - your solution works a treat!