# How to Create a Report in Airtable to Summarize Your Data

**URL:** <https://air.tableforums.com/t/how-to-create-a-report-in-airtable-to-summarize-your-data/227>\
**Category:** Tips & Tricks\
**Created:** [February 9, 2023, 9:02pm UTC](https://air.tableforums.com/t/how-to-create-a-report-in-airtable-to-summarize-your-data/227 "2023-02-09T21:02:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hannah\_Wiginton](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/hannah_wiginton/32/24_2.png) [@Hannah\_Wiginton](https://air.tableforums.com/u/Hannah_Wiginton)\
**Post date:** [February 9, 2023, 9:02pm UTC](https://air.tableforums.com/t/how-to-create-a-report-in-airtable-to-summarize-your-data/227/1 "2023-02-09T21:02:58Z")

</div>

You have all your data in Airtable and now you need to summarize and calculate all the information.

Reporting on business information is a vital part of company operations. **“How do I create a report in Airtable?”** is one of the common questions we see from Airtable users.

First, the answer is, “Yes, you can create reports!” You can create summary reports from your Airtable data, whether you need to summarize income, projects, sales, or information such as employee vacation hours or inventory totals.

In this tutorial, you’ll learn how to create summary reports in Airtable, how to automate record links to a report, and how to create a dashboard to showcase the information for others.

**See the full tutorial here:**

# [How to Create a Summary Report in Airtable](https://on2air.com/resources/airtablesummaryreport/)

* * *

## **The Basics of How to Create a Report in Airtable**

We get into the details of how to set up your own report in the step-by step tutorial, but here are the basics for creating a report in Airtable.

1. Create a new table in your base and name it **Reports**

 ![display of an Airtable base table called Reports](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/1X/baa34ac21418b3ee7f9a2ad9a297d2733f0a632c.png)

1. In the Reports table, add a [Linked record field](https://www.airtable.com/guides/build/connect-data-with-linked-records) related to the table that contains the data you want to summarize.

If you want to report on all Leads/Deals, then link to the table where your Leads/Deals data is stored.

 ![showcasing an Airtable linked record field](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/1X/86e33867624142f6551e96e17b5dac52db3dcb1c.png)

1. Add [Rollup fields](https://support.airtable.com/hc/en-us/articles/360042807233-Rollup-field-overview) with a [Rollup field formula](https://support.airtable.com/hc/en-us/articles/202576599-Rollup-field-reference) to calculate the data from your linked table.

**Rollup fields** allow you to look up data from Linked tables and join, summarize, or count that information.

Rollup Field formulas like _`COUNTALL(ARRAYUNIQUE(values))`_ or _`SUM(values)`_ are common

 ![display of Airtable rollup fields and how they display infor](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/1X/24719fb1176dbf8b8c1f6d98c51487963f5a1cae.png)

1. Create a single record in your Reports table and add any records from your Linked table that need to be included on the Report

 ![Create a single record in your Reports table and add any records from your Linked table that need to be included on the Report](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/1X/5d68fb332dce7faf8cced57ea451251cbd2a7f1b.png)

1. Your Report data will be automatically calculated

 ![Airtable record automatically calculated with Rollup fields](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/1X/13a8a55b61ee951e6f891eca21bcdfb580300256.png)

Once you have a Linked record field and a few Rollup fields set up, you’ll be able to create your own Reports any time you need!

🌟 Find a step-by-step tutorial with examples - **[How to Create a Summary Report in Airtable](https://on2air.com/resources/airtablesummaryreport/)**

---

<div class="post-metadata">

**Author:** ![ScottWorld](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/scottworld/32/5_2.png) [@ScottWorld](https://air.tableforums.com/u/ScottWorld)\
**Post date:** [February 10, 2023, 3:01am UTC](https://air.tableforums.com/t/how-to-create-a-report-in-airtable-to-summarize-your-data/227/2 "2023-02-10T03:01:34Z")

</div>

Wow!!! Thank you so much, @Hannah_Wiginton, for typing up this excellent, super-detailed post about one of the most commonly-requested questions about Airtable!! I’m sure that this will help every Airtable user who visits these forums! 🕶 🥂 ✨

---

<div class="post-metadata">

**Author:** ![Hannah\_Wiginton](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/hannah_wiginton/32/24_2.png) [@Hannah\_Wiginton](https://air.tableforums.com/u/Hannah_Wiginton)\
**Post date:** [February 13, 2023, 10:39pm UTC](https://air.tableforums.com/t/how-to-create-a-report-in-airtable-to-summarize-your-data/227/3 "2023-02-13T22:39:11Z")

</div>

Thanks Scott!  
It’s not easily understood how to do this when you’re starting to use Airtable and realize you need reporting features.  
Hope it helps many!