AnsweredAssumed Answered

How to sum purchases?

Question asked by brett_ on Jun 24, 2013
Latest reply on Jun 24, 2013 by brett_

Title

How to sum purchases?

Post

     I have Customer and 'Purchase Transaction' tables.  'Purchase Transaction' holds all the purchases a customer may have made.  When looking at customers, I'd like to see a total of their purchases.  

     I did create a calculation field in 'Purchase Transaction'.  It does a Sum( Purchase Price).  But all I see is the Purchase Price for the current row.  There is no summation of all purchases for that customer.  Any idea how this can be done?

Outcomes