Replace crosstab table with PivotTable report ignoring criteria range.
用数据透视表报表替换交叉表，忽略条件范围。
The form opens in PivotTable view.
窗体在数据透视表视图中打开。
For example, consider this PivotTable.
例如，像这样的透视表。
The Refresh Data operation changed the PivotTable report.
“更新数据”操作更改了数据透视表报表。
You cannot apply data validation to cells in a PivotTable.
不能对透视表应用数据有效性检验。
The data range you have selected includes a PivotTable report.
选定的数据区域包括一张数据透视表报表。
For more complex data layouts, you can use the PivotTable system.
对于更加复杂的数据布局，您可以使用PivotTable系统。
Un-checking a checkbox will remove the field from the PivotTable.
不勾选复选框的话，这些字段就会从数据透视表中移除。
To start with, imagine you were building the following PivotTable.
开始，想象一下你原来做下面这张表的时候。
This is going to be the last PivotTable post, at least for a while.
这是本阶段内最后一篇关于透视表的文章了。
This is done in the Report Layout drop down on the PivotTable Styles TAB.
这个命令已经设置在数据透视表样式标签的报告布局的下拉列表里。
You can replicate the format of PivotTable and PivotChart views in a form.
可以复制窗体的数据透视表视图和数据透视图视图的格式。
To illustrate, here is the PivotTable I've been using for other examples today.
举例，这儿是今天我们在其他例子已经使用过的透视表。
PivotTable view: A view that summarizes and analyzes data in a datasheet or form.
数据透视表视图：用于汇总并分析数据表或窗体中数据的视图。
References to subtotals and data items cannot be entered into PivotTable formulas.
在透视表公式中不能输入对分类汇总和数据项的引用。
Report filter. This area holds the fields that the whole PivotTable is filtered by.
报告筛选。这个区域保留整个数据透视表未被使用的字段。
Data will be saved with other PivotTables using the same source data as this PivotTable.
数据透视表保存的数据可与其他数据透视表共用同样源数据文件。
And now the PivotTable no longer contains the subtotals for Mountain Bikes and Road Bikes.
现在透视表不再包括山地自行车和公路自车的分类汇总项目。
The Excel pivot table was correctly created so a PivotTable toolbar displays over the window.
Excelpivot表已正确创建，所以窗口上显示一个PivotTable工具栏。
As you add fields to the Values area of the PivotTable, the formatting is done automatically.
当你添加字段到数据透视表的数值区域时，格式会自动完成。
At the top are the PivotTable menu and some toolbar buttons to control the depth of the table.
顶部是PivotTable菜单和一些用于控制表深度的工具栏按钮。
Say you have the following PivotTable and you want to display all the available details for Canada.
比方说你有下面这样的透视表，你想显示所有“加拿大”有用的细节。
Only one subtotal per row area, column area, or page area can be entered in a PivotTable reference.
在数据透视表中每个行区域、列区域或页区域只能有一个分类汇总。
There are four areas in a PivotTable, each of which is represented by a drop zone in the field list.
在数据透视表中有四个区域，在字段列表中每一个区域代表一个拖拽区域。
This TAB is designed to hold all the commands you would commonly use when working with a PivotTable.
这个标签用来容纳你在使用数据透视表时的所有常用命令。
This PivotTable is aggregating the source data using the Sum function. Now, let's try and change this to Count.
这个透视表是使用求和功能进行数据源汇总的。现在，让我们将它改为计数。
The PivotTable report was saved without the underlying data. Use the Refresh Data command to update the report.
数据透视表没有与下层数据共同保存。请使用“刷新数据”命令更新数据透视表。
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 分别具有一个工作簿。
Here is a screenshot of the dialog illustrating how to change the data source of a PivotTable based on an OLAP data source.
下面是对话框的一个截图，举例说明怎样改变一个基于OLAP数据源的数据透视表的数据源。
Another thing we hear from PivotTable users all the time is that it is too difficult or slow to clear stuff off of a PivotTable.
我们从数据透视表用户那里经常听说的另外烦恼就是清除数据透视表中的数据太困难或是太慢。
应用推荐