Dragging and dropping fields onto the Filter shelf will allow you to filter the view. It also allows you to give users the ability to filter data in the worksheet. In the following example, we want to allow users to be able to filter the view based on Market. After dragging the Market field to the Filters shelf, a Filter menu appears:
After clicking OK, right-click on the Market field in the Filters shelf, and click Show Filter.
You can now see the Market filter on the right-hand side of the screen. Add or remove the checkmarks next to the field values to filter the view, as shown in the following screenshot:
You can edit ...
