Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Overview revenue in a new table

Topic Labels: Base design
382 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,

I’m trying to understand Airtable better, so I’m hoping someone can help me out.

I have a table with projects, the month the project has to be finished and a estimation of the revenue.Schermafbeelding 2020-12-16 om 16

The next step is to create (with a new table, because a new grid view doesn’t do the trick) an overview of the revenue per month and per year in total. I just don’t understand how to create this. Who can help me out?

Thanks
Jos

1 Reply 1

If you have the Pro plan, you can use the Pivot Table app. Otherwise, I would suggest creating a new view where the records are grouped by month/year (create a new field if you need to). Then the summary bar (or whatever it’s called) at the top of each grouping can do arithmetic on numeric fields. Not sure what else to suggest.