This seems easy, but for some reason I cant wrap my head around how I need to use either summary fields, or a calculation to get the results I am looking for.
Basically I want show to a user a simple layout in FMGO13, that will show them how many jobs they have completed and how much those jobs were worth total, by month. I suppose at some point they might want to see what all the jobs were but right now I am just trying to get the basics down. Each job has a room (these are houses) and we bill by room so my tables are as follows:
So my tables are: Customer -< Room -< Line Items
How can I show this information on one layout? I am sure I am just overthinking this..