Filemaker is driving me nuts--list customers with sales of groups of item
I have a table that contains the following fields [store no], [article no], [sales]
I have a related table that has [article no], [category].
I want only the total sales by [store no] of the articles of a particular category.
I can get the numbers using a summary field in a report but I can't just make a list of [store no] and their sales by [category] ranked.
Called filemaker and offered to pay but they said it was simple and they would send me information on portals. I can tell by what I read on portals it will not give me the simple list I want. (they didn't send me any info either)
I am dealing with 42000 records about 1300 store numbers, 40 items about 20 of them are of the category I want.
Where is place I can learn to better data crunch with Filemaker? All their tutorials are long on format and appearance and short on data drilling. IMHO.