Sorry about the hastily drawn picture :)
The left table is a basic model that is showing a list of all my raw material inventory models.
The right table is an aggregate model with 2 layers of grouping that shows what that raw material makes as a finished good. That finished good grouping is used for a model lookup to a third aggregate model ( not shown ) that is describing the shipping demand for that finished good. The goal being that I want to know my total requirement for glue derived from all my finished good sales orders in the system.
The data here is all the correct and I am very close. My struggle is how to get the left table to show an aggregate answer for all the glue rows in the right table. The standard model lookup is finding the first value and presenting that. Is there any way to perform a model lookup loop or aggregate model lookup?
Thank you greatly for your assistance.