I have a table (AnnualInfo) that tracks several different measurements that are recorded annually but not necessarily at the same time. The table has an ID field, a year field, a weight field, a color field and a length field. So a table view of the records may loo like this:
I want a portal that will return all the items on one line per year. So the portal table results would look like this:
I can't figure out how to sum up all the records on one line per year. Assistance greatly appreciated!