Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Count & Summary

Topic Labels: Base design
Solved
Jump to Solution
403 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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