I am responsible for billing regular users of our Village Hall on a monthly basis. Currently, I export the data from the billing system, reduce the number of columns to the pertinent, sort by Hirer and then by date and then subtotal booking fee by Hirer and I end up with a sheet like this:
I have spent 3 or 4 days now trying to replicate this in Airtable, with no joy whatsoever. I have linked tables and tried to roll up, but I cannot figure out how to roll up for each hirer. The best I have managed is to group by hirer and manually copy the summarised price total to another sheet.
