Performing Calculations on Numerical Data
If the data is numerical, you can use the Query Wizard to set up calculations for you. Subtotal options work similar with the subtotal options in Excel.
Example
If you to view subtotals of customer's discount on a product, one way to do this is to generate the worksheet and use the Excel subtotal function to multiply the discount on the amount due for you. Another option is to do the same operation in the Query Wizard setup.