The Group Filter

The Group Filter groups the data rows in a datalayer and gives youthe ability to create aggregate values from the grouped rows.

The following topics discuss the Group Filter element:

• Grouping Data
• Grouping for Unique Rows
• Grouping on Multiple Columns
• Conditional Grouping
• Aggregating Grouped Data
• Using Group DrillThrough

About the Group Filter

The behavior of the Group Filter element is similar to that of the GROUP BY clause in a SQL query. However, unlike a query, the element applies its grouping to data after it's been retrieved into the datalayer. This is very useful as it allows grouping to be applied to all kinds of data, including data from sources that lack SQL-like features, such as XML files and web services.