Count & Summary

I need to create a summary table that counts the number of times an individual product shows up in a list of linked records.

For example, I have a table called “Assortments” and a table called “Fruits” that are linked. Assortment 1 has 2 apples and 2 pomegranates, while Assortment 2 has 1 apple and 2 pineapples. A third table, “Orders”, lists the assortments ordered.

How can I summarize the data from the “Orders” table into how many of each individual fruit has been ordered (X apples, X pomegranates, X pineapples)?

Hi @MikeG,

Welcome to Airtable Community! :slight_smile:

You can do that by using a Rollup Field in the Fruits table that rolls up the assortments.

If this helps you please mark this as Solution so others can see it.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.