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.

BR,
Mo

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