AnsweredAssumed Answered

Filemaker is driving me nuts--list customers with sales of groups of item

Question asked by MikeMassey on Feb 4, 2014
Latest reply on Feb 9, 2014 by MikeMassey

Title

Filemaker is driving me nuts--list customers with sales of groups of item

Post

     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.

Outcomes