Beginner here, asking a question which has no doubt been asked a lot and probably has a simple, obvious answer! Apologies in advance...
I have one table containing all of our customer bookings. In this table there is a formula field that takes the date that the booking was made and assigns it a week number based on a weeknum formula.
I have another table where I have the week numbers listed from 1-52 in a field. The outcome I want is to have other fields that adds up figures from the customer bookings that took place in the same week number. Simple SUM-like formulas that add up how long the bookings went for, how much they cost etc (all of which are fields in the original customer bookings tables).
I'm not sure if I'm using the correct terms when I am googling this info but I haven't found anything that helps as yet.
I made a mock base that might better show what I've got and what I want
Basically, I was hoping to have those Total hours and Total $$ fields autofill with the details based on the week number.
I hope that makes sense! Any help is greatly appreciated!
ps - Just so ya know, I'm aware I can filter a view in the original table that will show this data but I need it in it's own field so that I can export it!