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.

Subsummary parts are based on the Sort order. It will tell you what field it is attached to. If you change the found set you need to Sort again.