Help

New to AirTable - Need some help

Topic Labels: Formulas
494 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Shelly_Jansen
4 - Data Explorer
4 - Data Explorer

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
Nathaniel_Grano
8 - Airtable Astronomer
8 - Airtable Astronomer

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:

image