Help

Count & Summary

Topic Labels: Base design
Solved
Jump to Solution
841 1
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeG
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

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

See Solution in Thread

1 Reply 1
Mohamed_Swella1
13 - Mars
13 - Mars

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