Subtotals

  • Thread starter Thread starter David Hoyle
  • Start date Start date
D

David Hoyle

I have a query that sums the revenue for each order thus
Revenue: Sum(([Qty]*[Price]*(1-[Discount]))) I have
created a Report that gives the total of all orders by
using =Sum([Revenue]) in the Report footer. I now want to
include a subtotal of all orders for a particular
customer in the Report. What is the correct expression?
 
Its OK I have found the solution =Sum([Revenue]) in the Customer Header works once I rebuilt the report using levels
 
Back
Top