Creating a summary Table

[Junessa_Mendoza]

Hi folks! I’m a beginner with AirTable and I’m trying to figure out how to migrate my data from Google fusion tables to here. I’ve tried to manually migrate to AirTable each .csv file that I have imported to Fusion Tables. Now I want to create a Tab that would summarize my data by certain columns/fields (like date, SKU, quantity shipped and count).

I tried creating linking another record and creating a new table but I only get a summary for only one field. How do I summarize by various fields like mentioned above? Any inputs would be greatly appreciated!

[Jeremy_Oglesby]

To create summaries like that, you need to use lookup and rollup fields in addition to your linked records.

Without knowing how your base is structured, it’s difficult to give you specific advice on how to do that, but here are some help articles you can read:

Airtable - Support

A beginner's guide to many-to-many relationships

What sets Airtable apart from ordinary spreadsheet applications is its ability to link related concepts together. Knowing how to represent the relationships between different groups of objects can ...

Airtable - Support

Guide to formula, lookup, rollup, and other computed fields

Computed fields (columns) are special field types where the values in the field are computed by Airtable automatically, rather than directly edited by users. These can be fields that allow you to c...