Totaling hourly weight

[[email protected]]

I need to build a table that totals the weight for a tunnel by the hour. 10 possible tunnels by 12 hours, columns any date. I can do it by filtered portals then loop through and total the weight, but that is 120 portals and scripting. Does anyone have a better suggestion? This data is drawn from an ODBC linked product database. I first do a find for the date then use the portals to filter by the tunnel and hour, then use a script to loop through and total the weights.       

Edited August 1, 2016 by [email protected]
spelling

[comment]

it is very difficult to understand your description. In general, you would use a summary field to summarize data, and sub-summary parts to show sub-summary values for each sorted group.