AnsweredAssumed Answered

Summing and Sorting

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

Title

Summing and Sorting

Post

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

----------------------------------------------------------

Thanks

Outcomes