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.
Drag the Profit measure from the Data window
and drop it on the Filters shelf.
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.
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
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.
Select Filter on the Year(Order
Date) field menu.
In the Filter dialog box, deselect all years except 2011
and 2012 and then click OK.