数据透视表 字段交叉
One of the best features of a pivot table is filtering, which allows you to see specific results in your data. See which types of filters are available, and learn how you can apply more than one filter on pivot table field at the same time.
数据透视表的最佳功能之一是过滤,它使您可以查看数据中的特定结果。 查看可用的过滤器类型,并了解如何在透视表字段上同时应用多个过滤器。
数据透视表过滤器类型 (Pivot Table Filter Types)
Here are the types of pivot table filters that you can use:
以下是您可以使用的数据透视表过滤器的类型:
Add Report Filters at the top of the pivot table, to limit what's summarized in the pivot table data.
在数据透视表的顶部添加报告过滤器 ,以限制数据透视表数据中汇总的内容。
- Use Label, Value, and Manual filters on the pivot fields, to narrow the focus. 在枢轴字段上使用“标签”,“值”和“手动”过滤器来缩小焦点。
枢轴场过滤器 (Pivot Field Filters)
The pivot field filters are easy to use, and you can quickly change the pivot table report for different needs. However, you can only use those field filters one at a time, with the default pivot table settings.
数据透视表字段过滤器易于使用,您可以根据不同需求快速更改数据透视表报表。 但是,你只能使用那些领域的过滤器一次一个 ,默认透视表的设置。
So, if you apply a Value filter on a pivot field, then try to add a Label filter, the first filter is removed.
因此,如果您在枢轴字段上应用“值”过滤器,然后尝试添加“标签”过滤器,则会删除第一个过滤器。
It's possible to apply multiple pivot field filters at the same