
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2020 11:24 AM
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)?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2020 08:31 PM
Hi @MikeG,
Welcome to Airtable Community! :slightly_smiling_face:
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.
BR,
Mo

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2020 08:31 PM
Hi @MikeG,
Welcome to Airtable Community! :slightly_smiling_face:
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.
BR,
Mo
