Example 4 – Filter Data

In this example you will modify the view from Example 3 – Small Multiples to only show data for orders in 2011 and 2012 and made a profit.

1. Drag the Profit measure from the Data window and drop it on the Filters shelf.
   
   
2. Select the aggregation you want to use for the filter. For this example, select SUM to create a filter on the SUM of the profit data.
   
   Filtering aggregated data means that the selected aggregation function (sum, average, etc.) is applied to the data and then it is filtered. Filtering disaggregated data (All values) means that the individual data rows are filtered before any aggregation function is applied. Aggregations do not apply to multidimensional data because in those databases, the data has already been aggregated in the database.
   
3. In the Filter dialog box, use the sliders or type into the text box to change the lower limit on the range of values to 0.
   
   
4. When finished, click OK.
   The view updates to only show orders that had a SUM(Profit) over $0. No new axes were created because the field was not added to the Rows or Columns shelves.
   
5. Select Filter on the Year(Order Date) field menu.
   
   
6. In the Filter dialog box, deselect all years except 2011 and 2012 and then click OK.
   
   

The SUM(Profit) is calculated only for data rows where profit is greater than or equal to $0 and Order Date is 2011 or 2012.