How to show data (in the interface) of multiple tables

[Antonio_Forbes]

Hello,
I have an airtable dataset that includes:

• Customers: all the information about customers
• Trainings: all the information regarding each training (including the date)
• Inscriptions: that combine Trainings and Customers and also add extra info (e.g. how much the customer payed for the training)

I want to build a Dashboard Interface where someone could state a “start date” and “end date” and the dashboard would show:

• All the trainings in those dates: this seems easy, just used a grid of trainings filtered by those date inputs)
• The total of revenue from those Trainings

In the last bullet, how can I get the SUM of the revenue from all inscriptions in the trainings that are filtered by those dates?

Thanks a lot

[TheTimeSavingCo]

Hi Antonio, I’ve set something up here for you to check out

The idea is to add a rollup field to the Classes table that sums the amount per class. Then, in the interface, we create a Count element that will sum on that rollup, and connect it to the filter we’ve got set up for the grid

(Not too sure if I set up my base to be the same as yours; let me know if you hit any issues)