Performing Calculations on Numerical Data

If the data is numerical, you can use the Query Wizard to set up simple calculations for you. Subtotal options work exactly like they do 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.