Applying filter criteria before aggregation

If you use a relational data source, to apply the filter criteria before items are summed, you can select the Before Aggregation check box in the Edit Filter window.

Before you begin

You must create or edit a filter line from a relational data source.

Procedure

  1. From the Filter window, click the filter line, or if you are creating a new filter, click the Add a Filter Line icon.
  2. Select the Before aggregation check box.
  3. Click OK.