Data_Warrior Member

Are Building and Customer in the same series? If so, drag that series to Categories section in the edit view (click the pencil on the left) and filter the series to just building.

I found a solution outside of using SQL. You just use a running total bar graph of the difference between in and out.

That for some reason doesn't seem to capture beginning inventory in a relevant time period. Harkening back to the old accounting days: Beginning Inventory + Additions - Subtractions ------------------------ Ending Inventory

You rock! Thank you!