AnsweredAssumed Answered

Summing and Sorting

Question asked by EplotEplot on Jul 21, 2011
Latest reply on Jul 24, 2011 by EplotEplot


Summing and Sorting


Hi there,

We have some data/fields in a table that we want to sort and display the total quantity based on Customer and Quantity, what is the best way to do it using filemaker to make a layout displaying the data?

We have three fields to sort Customer, Product Code & Qty

Customer Product Code Qty
A Apple 2
A Oranges 1
A Oranges 3
A Apple 5
B Apple 2
B Oranges 2
B Apple 3

We would like to have an end result like this:-

Customer Product Code Total Qty
A Apple 7
A Oranges 4
B Apple 5
B Oranges 2