How to sum purchases?
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?