Help

Using grouped totals on a new page

575 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Britney_Keller
4 - Data Explorer
4 - Data Explorer

I have a column of our total bins sold, which is then grouped by size. What I would like to be able to do is take our “total bins on hand” and then subtract the total ordered, as listed in these columns.

So basically if we have 25 ‘1805 bins’ on hand, and we’ve sold 10 of those, I want to know how many I have remaining. We sell numerous sizes of bins. I need to know per size.

I have my table made to track my orders, now I just need to link that to our total Bins to sell . If that makes sense. I tried to attach a photo here but it says I can’t.
I am very new to airtable so hopefully I’m working in the right direction here. Trying to very simply track our inventory.

1 Reply 1
victor_alumanah
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi There,
Maybe you can create another table and link it to the Bins table, the using the “Rollup” feature you can get the sums.

Thanks
Victor