For more complex data layouts, you can use the PivotTable system.
对于更加复杂的数据布局，您可以使用PivotTable系统。
The example PHP application builds an Excel XML file that has one worksheet for the raw data and another for the PivotTable.
示例PHP应用程序构建一个ExcelXML文件，其中为原始数据和PivotTable 分别具有一个工作簿。
To build a pivot table in Excel, you select the data columns to be used in the pivot table, then select the PivotTable Report menu item from the data menu.
要在Excel中构建pivot表，您需要选择将用在pivot表中的数据列，然后从Data菜单选择PivotTablereport菜单项。
References to subtotals and data items cannot be entered into PivotTable formulas.
在透视表公式中不能输入对分类汇总和数据项的引用。
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.
从本质上讲，这是相同的命令，除非当你使用这个命令时，我们知道你想把你正在操作的列表作为数据透视表的源数据。
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.
从外部数据连接（或所有工作薄连接中）读取数据，并且更新相关单元格的值，例如，数据透视表单元格或三维公式的结果。
Here is a screenshot of the dialog illustrating how to change the data source of a PivotTable based on an OLAP data source.
下面是对话框的一个截图，举例说明怎样改变一个基于OLAP数据源的数据透视表的数据源。
This PivotTable is aggregating the source data using the Sum function. Now, let's try and change this to Count.
这个透视表是使用求和功能进行数据源汇总的。现在，让我们将它改为计数。
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.
在下面的数据透视表里，我在看不同型号自行车的销售情况，我已经做好了我的报告，其中一列是每年的销售数据。
The data range you have selected includes a PivotTable report.
选定的数据区域包括一张数据透视表报表。
You cannot apply data validation to cells in a PivotTable.
不能对透视表应用数据有效性检验。
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.
这就是数据透视表用计数代替求和来汇总数据源的全部内容。这儿是这一结果的截图。
The PivotTable report was saved without the underlying data. Use the Refresh Data command to update the report.
数据透视表没有与下层数据共同保存。请使用“刷新数据”命令更新数据透视表。
PivotTable view: A view that summarizes and analyzes data in a datasheet or form.
数据透视表视图：用于汇总并分析数据表或窗体中数据的视图。
Data will be saved with other PivotTables using the same source data as this PivotTable.
数据透视表保存的数据可与其他数据透视表共用同样源数据文件。
The Refresh Data operation changed the PivotTable report.
“更新数据”操作更改了数据透视表报表。
To create a PivotTable report, you must use data that is organized as a list with labeled columns.
在创建透视表时，必须使用组合为带有标志列列表的数据。
You cannot apply data validation to cells in a PivotTable.
或者用数据源中有效的合并域来替换。
Occurs after a PivotTable report opens the connection to its data source.
在数据透视表打开到其数据源的连接后发生。
One of our goals while designing the PivotTable component was to make the user interface and programming model consistent between tabular and multidimensional data sources.
我们设计透视表组件的目的之一，就是使表列数据源和多维数据源的用户界面和编程模型保持一致。
PivotTable was changed during Refresh Data operation.
“更新数据”操作更改了数据透视表报表。
PivotTable was changed during Refresh Data operation.
“更新数据”操作更改了数据透视表报表。
应用推荐