Is there any way to pull in summarized data from one table into another?
For example, I’m tracking invoices (as rows) that are grouped by an assigned category on one table. Airtable will provide a nice little summary for each category grouping.
For reasons (related to creating more robust pivot tables), I’d like to create another table where each invoice category is its own record, and the column would have its summary figure.
I’m aware this is possible through roll-ups, however, if I understand correctly, to achieve this, I would have to manually link each invoice record from the original table in the linked field column. This is simply unsustainable given the large amount of records. It would be a different story if I could create a formula/filter that would automatically grab all of the records I wanted to reference.