This is probably a simply question for all of you, but I am new to filemaker and databases in general. I have looked all over and either don't understand what I have found as the answer or can't find it. I am tracking sales in several categories in several stores. I would like to be able to pull out the total sales for each store/district for some period. I don't want to see the weekly sales, just the totals.
store a 12,345
store b 10,125
store c 14,324
etc...
I then need to export this to an excel file (which I am not currently having problems with). I have had minor success by setting up a layout with summary fields using the wizard. I did a search for the data set I want. Then deleted the fields out of the body. This came close enough to be usable, but as soon as I ran a new search, it didn't work anymore.
I am using 8.5 on OSX.
Thank you for your help.