summary fileds only in export to xls

[Jake molenkamp]

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.

[Fenton]

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.