Trying to create a simple BAQ that shows every customer and their total purchases to date. Do I need to make a calculated field? and how would I go about doing that?
Yes. You will group on the customer info (check the Group By box in the Display Fields tab). Then for your sales you will make a calculated field that will be something like:
sum(InvcDtl.ExtPrice)
If you need to refine it to include date or time-frame info, you’d add those type of fields as calculated fields or possibly using the Fiscal Year and Fiscal Period from InvcHead and then check the Group By box for those as well.