Create a filter expression based on minimum and maximum values

Create minimum and maximum values in the cells of the exploration sheet to use in the filter expression.

Procedure

  1. From the exploration bar, click Filter and then click Edit/Add filter.
    The Filter window appears.
  2. Click Edit/Add filter.
    The Edit Filter window appears.
  3. Click Enter a cell reference.
  4. In the GO Sales (query) pane, click Unit price - Unit cost.
  5. In the operator box, click > (Greater Than).
  6. In the cell reference box, which appears after the operator, type J4, and then click OK.
    The Edit Filter window closes.
  7. Click the Add a Filter Line icon.
    The Edit Filter window appears.
  8. Click Enter a cell reference.
  9. In the GO Sales (query) pane, click Unit price - Unit cost.
  10. In the operator box, click <(Less Than).
  11. In the cell reference box, which appears after the operator, type J5, and then click OK.
    The Edit Filter window closes.
  12. Click OK.

Results

You observe that the results of the list exploration change because of the filter expressions you create. You limit items in the list exploration because of the minimum and maximum values that you control as static values in the cells of the exploration sheet.

By limiting the data in your exploration, you are better able to focus on key performance indicators. You can add filter expressions to limit data to specific dates by adding filter lines that use the Introduction date.