Skip to main content
Question

Creating Summary table for sales

  • May 26, 2025
  • 2 replies
  • 61 views

Forum|alt.badge.img+3

Hello folks, 

I am new to Airtable, any help is highly appreciated. 

I have different tables under the same base that tracks existing inventory and sales. I would like to create a third table that summarizes data for example I would like each row to represent a month and calculate profit/loss for that month but if I use rollup or formula fields it will apply the same formula into entire column which doens’t help my case. I need unique calculations to be carried for each row as each row will represent a month. 

2 replies

Forum|alt.badge.img+3
  • Author
  • New Participant
  • May 26, 2025

Figured it out, in case someone else is having the same problem, Here is what I did

I Created a link to each table from summary table and added links for the records that were relevant for that specific row and then used rollups to calculate sums. 


Mike_AutomaticN
Forum|alt.badge.img+28