開始使用免費開始

Selecting filters

Now that you know how to create the body and layout of a pivot table, let's start organizing the data.

One option is to filter the data. You can do this by selecting a field in the Filter section of the pivot table editor.

This will then give you the option to filter based on the contents of that field.

本練習屬於課程

Google Sheets 的樞紐分析

檢視課程

練習說明

  • Click on the Add button in the Filters section and select Month.
  • Once the Month box appears, you can then click the dropdown box that appears, and select an individual month. This time, select January.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習