Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

New to AirTable - Need some help

Topic Labels: Formulas
94 1
Showing results for 
Search instead for 
Did you mean: 

I have an Inventory base that was not created by me, but I’m the owner now. I have a Materials Checked In table, that I need to sum up the qty received by PO and description.

I tried using the Roll up, but it pulls all of the items by description, which is not helpful when I need to see items received by PO. This way I can see the Ordered Qty, Received Qty, then have an Open balance remaining per PO.

Screenshot 2022-11-17 193142

1 Reply 1

Try using the “Group By” setting for the view. You can group by PO first, then description. The view will show you totals and subtotals for each group and subgroup: