Hello,

I'm looking to summarize data for multiple locations of inventory.

For example, if I have three inventory locations (SI, TO, WG) and each location has nine Product Lines (AA, AB, AC, AD, AE, AF, AG, AH, AI). I'm looking to summarize as follows at the bottom of a report.

Location Product Line Total Inventory Cost/location
SI            AA             =sum of all AA parts x cost
TO            AA             =sum of all AA parts x cost

etc. Any thoughts on how I can go about this?