PivotTable data的意思|示意

This is essentially the same command, except when you use this command, we know that you want the table you are working with to be the data source for the PivotTable.

从本质上讲，这是相同的命令，除非当你使用这个命令时，我们知道你想把你正在操作的列表作为数据透视表的源数据。

In the PivotTable below I'm looking at sales for different bike models, and I have arranged my report so that I have a column with sales data for each year.

在下面的数据透视表里，我在看不同型号自行车的销售情况，我已经做好了我的报告，其中一列是每年的销售数据。

Refresh: Read data from an external data connection (or all of the workbook's connections) and refresh the values in the relevant cells, e. g. in PivotTable cells or in the results of cube formulas.

从外部数据连接（或所有工作薄连接中）读取数据，并且更新相关单元格的值，例如，数据透视表单元格或三维公式的结果。

And that's all it takes to have the PivotTable use Count instead of Sum to aggregate the source data. Here is a screen shot of the result.

这就是数据透视表用计数代替求和来汇总数据源的全部内容。这儿是这一结果的截图。

To create a PivotTable report, you must use data that is organized as a list with labeled columns.

在创建透视表时，必须使用组合为带有标志列列表的数据。

Data will be saved with other PivotTables using the same source data as this PivotTable.

数据透视表保存的数据可与其他数据透视表共用同样源数据文件。