OBI Answers: Add a Filter
To create a simple perform the following steps:
Step 1
Select the Sales History (SH) Subject Area
Step 2
In the left-hand selection pane expand the Customers table and click the Cust City column.
Expand the Measures > Sales Facts table and click the Gross Profit column.
Step 3
Your query should look like this.
Step 4
Click on the Results Tab to run the report. The results should look like this:
Step 5
Click on the Criteria Tab.
Step 6
Add a filter to display only Cities with Gross Profits greater than $0.25M.
There are 2 ways of doing this. Either,
- Hold down the ‘Ctrl key’ and click on the Gross Profits column in the left-hand pane, or
- Click on the Add Filter icon
on the Gross Profit column under the Criteria Tab
The following screen will popup.
Step 7
Select the ‘is greater than’ value from the Operator dropdown list.
Enter the value 250000.
Click ‘OK’ to save the filter.
Step 8
The following should appear under the Filter Heading.
Step 9
Test the filter. Click on the Results Tab to run the report. The results should look like this:
