Subtotals

[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?

 

[Guest]

Its OK I have found the solution =Sum([Revenue]) in the Customer Header works once I rebuilt the report using levels