How to make a total based on parameters.
I have made a really basic database for keeping track on receipts. 1 table and 3 layouts, so nothing fancy - since I'm still in the filemaker learning process.
On every receipt record there is different fields. one for 'date', 'season', 'description', 'category', and 'seller'. Now I just want to make a layout so I can keep track on how much im spending at each 'season' in different categories. So fx. a calculation that will calculate how much total have I spend at: 'Winter season' in the 'sports' category. How do I set this up? tried all sorts of things, imagine it to be quite basic, though it haven't really worked out for me.?