Grouping, Summing up
I just started using FileMaker (working with File Maker Pro 12 Advanced), and I need to create something similar with the example below:
I have a table (like the one below):
From that table I need to Sum up "Cars" for TX (Houston+Austin, etc), and "Cars" for NY(New York+Albany, etc), to get a summary with the total number for each state like below:
Can someone please help - what would be the right approach ?
Appreciate any help !!