Filtering aggregate data In a summary table, the process to define a filter condition is similar to defining a filter condition for a detail table. As in a detail table containing aggregate data values, in a summary table, you can specify whether to display aggregate data, such as subtotals and grand totals, for all the rows retrieved from the data set, or for only data rows that meet the filter condition. This feature is useful when you create a filter for the purpose of excluding certain values, such as a list of geographies with no active marketing campaigns, or comparing a subset of data with the original. When you define a filter condition on a measure column, BIRT Studio displays a preview of the data rows that meet the specified condition. To display updated aggregate data in the summary table, in Filter, accept the default selection of Recalculate Totals. Any subtotals and grand totals in the summary table are calculated across the filtered data rows in the report design. To calculate aggregate data across all data rows retrieved from the data set, and not just the subset of filtered data, in Filter, deselect Recalculate Totals. You can specify whether to recalculate totals when creating a simple filter using the Filter dialog box, in Advanced Filter, as well as when filtering the top or bottom values in a summary table.
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy
