You can use filters to display aggregate values according to certain conditions.
Note:
Reports Studio displays only a preview of the actual data. This means that when you aggregate data or filter aggregate data values, the resulting table displays different results in Report Studio than in the interactive viewer. Report Studio applies the specified aggregation function or filter condition to the previewed data. Always view the table in the interactive viewer to verify that the results are what you expect.
When you create a filter condition that excludes certain values, such as viewing transactions that closed over a month ago or listing products that are not the top five selling products, Report Studio recalculates the aggregate data according to the data Analytics Studio retrieves. In some cases, it is also useful to view aggregate values for the unfiltered data, for example, to apply percentage calculations on this data. To address both situations in detail tables containing aggregate data, Report Studio provides an option in the Filter, Advanced Filter, and Top/Bottom N dialog boxes to specify whether to recalculate aggregate data based on the filter condition created, or not.
To filter aggregate values
- Select and right-click the aggregate value. Select Filter > Filter or Filter > Top/Bottom N.
- Define a filter condition. Analytics Studio evaluates the condition, and displays the resulting data in the table.
- Run the report in the interactive viewer to verify that the results are what you expect.