用数据透视表报表替换交叉表，忽略条件范围。
Replace crosstab table with PivotTable report ignoring criteria range.
窗体在数据透视表视图中打开。
创建新的数据透视表或图表。
出现的数据透视表中查看和打印时得到改善。
The appearance of pivot tables in the Viewer and when printed was improved.
然后，数据透视表仅用一次更新便完成了修改。
然后，可以用新的电子表格创建图表、数据透视表等。
You can then create charts, data pivot tables, and so forth with the new spreadsheet.
不勾选复选框的话，这些字段就会从数据透视表中移除。
Un-checking a checkbox will remove the field from the PivotTable.
报告筛选。这个区域保留整个数据透视表未被使用的字段。
Report filter. This area holds the fields that the whole PivotTable is filtered by.
这个标签用来容纳你在使用数据透视表时的所有常用命令。
This TAB is designed to hold all the commands you would commonly use when working with a PivotTable.
可以复制窗体的数据透视表视图和数据透视图视图的格式。
You can replicate the format of PivotTable and PivotChart views in a form.
当你添加字段到数据透视表的数值区域时，格式会自动完成。
As you add fields to the Values area of the PivotTable, the formatting is done automatically.
数据透视表视图：用于汇总并分析数据表或窗体中数据的视图。
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.
这个命令已经设置在数据透视表样式标签的报告布局的下拉列表里。
This is done in the Report Layout drop down on the PivotTable Styles TAB.
在数据透视表中每个行区域、列区域或页区域只能有一个分类汇总。
Only one subtotal per row area, column area, or page area can be entered in a PivotTable reference.
正如我在以前的文章中所说，数据透视表主要用于处理大量的数据。
As I said in the previous post, PivotTables are great for summarizing large amounts of data.
文章介绍了数据透视表的功能和作用以及馆藏数据透视表的创建和操作。
This paper introduced the function and usage of Pivo table, and its establish-ment and operation.
在数据透视表中有四个区域，在字段列表中每一个区域代表一个拖拽区域。
There are four areas in a PivotTable, each of which is represented by a drop zone in the field list.
下次，介绍数据透视表更多的特性，这些特性让数据透视表更易于理解和学习。
Next time up, a bunch more features that make PivotTables easier to read and explore.
一旦用户选择这两个命令的其中之一时，会出现一个创建数据透视表的新对话框。
Once the user selects one of these commands, they are presented with a new dialog for creating PivotTables.
数据透视表没有与下层数据共同保存。请使用“刷新数据”命令更新数据透视表。
The PivotTable report was saved without the underlying data. Use the Refresh Data command to update the report.
今天就介绍到这里。我们将乐意听到您的反馈意见。明天，介绍数据透视表的样式。
That's it for today. We would love to hear your feedback. Tomorrow, PivotTable styles.
这就是数据透视表用计数代替求和来汇总数据源的全部内容。这儿是这一结果的截图。
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.
通过数据透视表对各个必要的角度进行分析，进而了解应该在哪些地方改善预测过程。
All the necessary angles should be analysedvia a pivot table to discover where we should improve the forecasting process.
通常，当我们谈到交互时，一般集中谈论在工作表、列表和数据透视表中所能实现的功能。
Generally, when we talk about interactivity, we generally group the features we enabled into three areas: worksheets, tables, and PivotTables.
与一些开源产品不同，它可以处理复杂对象，包括命名范围、数据透视表、拆分框架和图表。
Unlike some of the open source products, it can work with complex objects, including named ranges, pivot tables, split frames, and charts.
成员属性也可以添加到数据透视表本身内部，当你需要打印该信息或者只是想让它时时可见。
The member properties can also be added inside the PivotTable itself when you need to print the information or just have it be visible all the time.
上面的截图表明，新的紧凑形式的最大优点就是数据透视表能够充分利用空间，更易于阅读。
As the screenshots above illustrate, the great advantage of the new compact form is that the PivotTable utilizes space a lot better, making it much easier to read.
我们从数据透视表用户那里经常听说的另外烦恼就是清除数据透视表中的数据太困难或是太慢。
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.
下面是对话框的一个截图，举例说明怎样改变一个基于OLAP数据源的数据透视表的数据源。
Here is a screenshot of the dialog illustrating how to change the data source of a PivotTable based on an OLAP data source.
应用推荐