I'm looking to make a table in Airtable that can sum a column based on the unique combination of other columns. Below is a sample of how I would do this in Excel using a pivot table.
The use-case is we are trying to create a labor tracking system for our manufacturing floor. Team members come in and work on different assemblies, parts and operations. Generally, there can be two records for the same combination of columns (a real example would be someone spends 4 hours on Thursday working an assy/part/operation, they submit their time tracking form for the day and then return on Friday and spends another 2 hours on that assy/part/operation to complete the job).
How can I achieve this? I thought I could do it with the Uniquearray function but unforunately cannot seem to get the solution working properly. Thanks in advance!