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.