excel 中有个设置是show items with no data，请问在哪里可以找到？

Question

如题所述

Answer 1

在数据透视表（Pivot Table） -pivot table options -display下进行设置。

The “Show items with no data on rows” and “Show items with no data on columns” checkboxes only applies to PivotTables based on OLAP data sources. They control whether we use the NON EMPTY keywords when querying the OLAP server. As an example, if you are looking at sales data by product groups, when these checkboxes are checked, the PivotTable will display a product group even if no sales were ever made for this product group. By default these checkboxes are not checked and we do not show items with no data. While this is available in the object model in current versions of Excel, we get a lot of customer requests to see this in the product, so we elevated it to mainline UI.
“显示无行数据项目”和“显示无列数据项目”复选框只对基于OLAP数据源的数据透视表有效。它们控制我们在查询OLAP服务器时是否使用NON　EMPTY关键字。例如，如果你在产品组中查看销售数据，当这些复选框被选中时，即使在此组产品中没有销售记录，数据透视表也将显示此产品组。。默认状态下这些复选框是没有选中的，所以我们不会显示没有数据的项目。虽然当前的Excel版本的对象模型中这些功能可用，但许多用户要求在产品中看到此功能，于是我们将其提升到了主要用户界面中。

Answer 2

因为我的是中文版，所以有些就不太清楚。
这个必须在数据透视表（Pivot Table） -pivot table options -display下进行设置。
另外网上找了一下，给你参考：
The “Show items with no data on rows” and “Show items with no data on columns” checkboxes only applies to PivotTables based on OLAP data sources. They control whether we use the NON EMPTY keywords when querying the OLAP server. As an example, if you are looking at sales data by product groups, when these checkboxes are checked, the PivotTable will display a product group even if no sales were ever made for this product group. By default these checkboxes are not checked and we do not show items with no data. While this is available in the object model in current versions of Excel, we get a lot of customer requests to see this in the product, so we elevated it to mainline UI.
“显示无行数据项目”和“显示无列数据项目”复选框只对基于OLAP数据源的数据透视表有效。它们控制我们在查询OLAP服务器时是否使用NON　EMPTY关键字。例如，如果你在产品组中查看销售数据，当这些复选框被选中时，即使在此组产品中没有销售记录，数据透视表也将显示此产品组。。默认状态下这些复选框是没有选中的，所以我们不会显示没有数据的项目。虽然当前的Excel版本的对象模型中这些功能可用，但许多用户要求在产品中看到此功能，于是我们将其提升到了主要用户界面中。本回答被提问者采纳