开始使用免费开始使用

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 中的 Pivot Table

查看课程

练习说明

  • 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.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习