用数据透视表报表替换交叉表，忽略条件范围。
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.
目的探讨基于数据透视表的病案首页数据查询技术。
Objective Discuss the technique of the data query in the first page of medical records based on pivot table.
不勾选复选框的话，这些字段就会从数据透视表中移除。
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.
您也可以通过工作项列表创建数据透视表和数据透视图报表。
You can also create PivotTable and PivotChart reports from a list of work items.
数据透视表视图：用于汇总并分析数据表或窗体中数据的视图。
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.
在数据透视表中每个行区域、列区域或页区域只能有一个分类汇总。
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.
一旦用户选择这两个命令的其中之一时，会出现一个创建数据透视表的新对话框。
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.
这就是数据透视表用计数代替求和来汇总数据源的全部内容。这儿是这一结果的截图。
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.
名称集显示在数据透视表的字段清单里，因此用户可以添加到数据透视表的行或列中。
Named sets are displayed in the PivotTable field list so that users can add them to a PivotTable on rows or columns.
通常，当我们谈到交互时，一般集中谈论在工作表、列表和数据透视表中所能实现的功能。
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.
点击清除全部以后，你将回到数据透视表最初创建时的状态(就像你还没有添加任何字段以前)。
After clicking Clear all, you are at the same state as when the PivotTable was originally created (as if you hadn't added any fields yet).
“显示无行数据项目”和“显示无列数据项目”复选框只对基于OLAP数据源的数据透视表有效。
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.
“显示无行数据项目”和“显示无列数据项目”复选框只对基于OLAP数据源的数据透视表有效。
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.
应用推荐