You can use Filter, Filter Bar, Filters to filter data. You can set filter conditions as required to obtain the required results.

Scenario: Compare shipping costs for East China, South China, and North China. This example is based on the company_sales_record dataset.

Prepare a workbook

You can create the following workbook based on the company_sales_record dataset and name it Shipping costs. For more information basic workbook operations, see Workbook overview and Create a workbook.

Filter

The filter is a feature of a workbook. You can use a filter to filter data of a workbook.

  1. In the Shipping costs workbook, select the area column or all of the data contained in the column.
    Note You must select the area column or all of the data contained in the column to ensure a successful filter.
  2. Click the Filter icon, select Filter as shown in the following figure.

  3. Click the drop-down arrow for the area column, select East, South, and North, and click OK as shown in the following figure.

The filter results are shown in the following figure.

Filter bar

You can use Filter Bar to filter target data.

  1. In the Shopping costs workbook, click Filter Bar and +Add Correlated Datasets as shown in the following figure.

  2. Double click the area field or drag this field to the Filter Fields area and click the Set Filter icon as shown in the following figure.

  3. In the Set Filter dialog box, configure the options as shown in the following figure and chooseOK > OK.

  4. Click Search to obtain the results as shown in the following figure.

Filters

When you create a workbook, you can use the Filters feature to filter data.

  1. When you create a workbook, drag the area field to the Filters area and click the Set Filter icon as shown in the following figure.

  2. In the Set Filter dialog box, configure the options as shown in the following figure and chooseOK > OK.

  3. Click Update. The filter results are shown in the following figure.