Count & Summary

[MikeG]

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)?

[Mohamed_Swella1 · Accepted solution]

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