You are right. So in this case I have the following listing as the results:
Company: Year/Month: Part: Change: = Production - Demand
If I change this top-level to a CTE that means that this will be my anchor point, right? The way I was trying to do it before was to have the current on-hand qty first and try to iterate by the change shown for each month.
Currently, I have the CTE set the way you said and I have linked the current on-hand qty as the union. Unfortunately, this doesn’t quite seem to work. I have been taking notes from the following post. The new version of BAQ listed:
AGDB_BI_SpplyDmnd02Rec2.baq (235.7 KB)