Hi there!
Not sure if there is a more elegant way to do this, but you could use a conditional rollup for each department. On your [Expenses] table, add one field for each department with a formula like…
IF({Department} = "Admin", {Qty}, 0)
Then, create rollup fields on your rItems] table that point at the new fields you just created on the eExpenses] table (one for each department, like in your screenshot above), with the formula…
SUM(values)
Again, it’s not super elegant - but it should get the job done
Hi there!
Not sure if there is a more elegant way to do this, but you could use a conditional rollup for each department. On your [Expenses] table, add one field for each department with a formula like…
IF({Department} = "Admin", {Qty}, 0)
Then, create rollup fields on your rItems] table that point at the new fields you just created on the eExpenses] table (one for each department, like in your screenshot above), with the formula…
SUM(values)
Again, it’s not super elegant - but it should get the job done
I’m not sure I see how that would work -
Here is how expenses are recorded

Or maybe I need to redo the whole thing.
I’m not sure I see how that would work -
Here is how expenses are recorded

Or maybe I need to redo the whole thing.
I don’t think you’d need to redo it… From what I can see it looks like it’s set up just fine! However, without seeing how the other tables are set up it’s hard to tell you if what I mentioned would work/even be practical. If you have lots of different options for {Department/Class}, you might want to go in a different direction.
The sample base below shows what I’m talking about - I used three departments as an example.
Explore the "Items/Departments (Example Base)" base on Airtable.
You can also read more about conditional rollups here
I don’t think you’d need to redo it… From what I can see it looks like it’s set up just fine! However, without seeing how the other tables are set up it’s hard to tell you if what I mentioned would work/even be practical. If you have lots of different options for {Department/Class}, you might want to go in a different direction.
The sample base below shows what I’m talking about - I used three departments as an example.
Explore the "Items/Departments (Example Base)" base on Airtable.
You can also read more about conditional rollups here
OKay I think I see what you mean, I think the sheer number of Items and departments might make that less do-able in this case.
But I REALLY appreciate you taking time to show me how to get it done.
If you instead record the department as a Single Select or a Link to Another Record type field, you could use the Pivot Table block as opposed to having a thousand columns