Welcome to the community, @BRIGITTE_BARIL! :grinning_face_with_big_eyes: Summary tables are definitely doable, but it will require linking records from your current table to the summary table to pull the data across. It also depends on how you’ve designed your current table. Are you able to share screenshots of your current table design?

Hello!


Here is what I am trying to do (this is from excel).


In Air table I can do the document with all the data, its the results I don’t know how to do.


So picture A I can reproduce in airtable


its picture B that I would need to create. This show results for 1 hotel but there are the same results for other hotels. I need a quick view for my directors to se the entire picture at a glance





.


thankyou for taking the time to help!

Thanks for the update. In this case, I would recommend creating a second table named “Hotels”, with each record being a separate hotel, including the per-night stay cost for the hotel. In your primary table each record would represent a single person and contain all of the data for that person’s stay. To connect them to a hotel, add a link field to the eHotels] table. You could then bring in the hotel’s per-night cost via a lookup or rollup field (for a single value like this, a lookup will work fine, but be aware that lookup fields often return arrays of values, which don’t always process cleanly; more on that in the base that I shared in this other thread), and use formula fields to calculate the person’s total stay cost. Over in the Hotels] table, you’ll have incoming connections for all linked people, and you can use rollup fields to tally the total costs of all people staying at each hotel.