Explorations using filters

When working with dimensional data, you can use context filters to quickly focus your report on a particular view of the data. You can also use custom filters to refine your view.

In this topic, you will learn how to

create context filters by dropping members or sets in the context filter area
create a custom filter by creating an expression that you use to retrieve a specific subset of records

It should take 10-25 minutes to complete this topic. To view the completed report, download the CustomFilter.xls sample workbook.

The Exploration View contains product lines in the rows, years in the columns, and returns as the measure. The values are filtered to show returns for only Web orders from the Americas. We use a custom filter to narrow the focus of this report to show only those product lines that have generated over 5000 returns in 2013.