可能经常需要创建包含LotusNotes应用程序数据的邮件、特定格式的报表，或者支持数据透视表等特性。
You might frequently need to create mail merges with data in Lotus Notes applications, to create reports with specific formatting, or to enable features such as pivot tables.
从本质上讲，这是相同的命令，除非当你使用这个命令时，我们知道你想把你正在操作的列表作为数据透视表的源数据。
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.
为了在数据透视表里面提供一个强大的条件格式体验，我们现在将条件格式的规则与数据透视表联系起来，而不是与单元格了。
To provide a great experience with conditional formatting inside PivotTables, we now associate the conditional formatting rules to the structure of the PivotTable instead of to the cells.
我们从数据透视表用户那里经常听说的另外烦恼就是清除数据透视表中的数据太困难或是太慢。
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.
由于数据透视远较列表复杂，所以数据透视表得增加更多的元素，以便可供用户利用，实现各种格式设置。
The additional elements are due to the fact that PivotTables are more complex than tables, so there are more table elements available for users to define formatting on.
下次，介绍数据透视表更多的特性，这些特性让数据透视表更易于理解和学习。
Next time up, a bunch more features that make PivotTables easier to read and explore.
“显示无行数据项目”和“显示无列数据项目”复选框只对基于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.
这就是数据透视表用计数代替求和来汇总数据源的全部内容。这儿是这一结果的截图。
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.
正如我在以前的文章中所说，数据透视表主要用于处理大量的数据。
As I said in the previous post, PivotTables are great for summarizing large amounts of data.
数据透视表保存的数据可与其他数据透视表共用同样源数据文件。
Data will be saved with other PivotTables using the same source data as this PivotTable.
数据透视表没有与下层数据共同保存。请使用“刷新数据”命令更新数据透视表。
The PivotTable report was saved without the underlying data. Use the Refresh Data command to update the report.
这是条件格式和数据透视表的总结。有了这些改进，数据透视表可以作为一个强大的数据研究，突出趋势，发现突出者，等等的工具来使用了。
That's the summary for conditional formatting and PivotTables. With these improvements, PivotTables can now be used as a great tool for exploring data, highlighting trends, spotting outliers, etc.
需要注意的是，与列表风格相比较，数据透视表在颜色和字体上有很大的不同，实现区分不同级别的数据。
One thing to note that is quite different when compared to Table Styles is the use of colour and font to identify levels in the data.
可以复制窗体的数据透视表视图和数据透视图视图的格式。
You can replicate the format of PivotTable and PivotChart views in a form.
“成员属性工具提示”控制当鼠标停留在项目的行和列上面时是否在工具提示上显示成员属性(只有当数据透视表基于OLAP数据源时才有效)。
"Tooltips with member properties" controls whether member properties are displayed in tooltips when hovering over items on rows and columns (only applicable to PivotTables based on OLAP data sources).
数据透视表视图：用于汇总并分析数据表或窗体中数据的视图。
PivotTable view: A view that summarizes and analyzes data in a datasheet or form.
在Excel12里，我们增加了数据透视表样式，使得数据透视表可读性更强，这也是我们工作中的另一个重要部分。
In Excel 12, we have added PivotTable styles, which are another important part of our work to make PivotTables easier to read and understand.
文章介绍了数据透视表的功能和作用以及馆藏数据透视表的创建和操作。
This paper introduced the function and usage of Pivo table, and its establish-ment and operation.
在我们的例子里，因为当我们创建数据透视表时已经选择了一个列表，所以用户所要做的就是点击“OK”，那么数据透视表就创建完成了——这总共只需要点击两次鼠标。
In our example, because we had a table selected when we created the PivotTable, all our user has to do is to click OK and the PivotTable is created - that's a total of two clicks.
目的探讨基于数据透视表的病案首页数据查询技术。
Objective Discuss the technique of the data query in the first page of medical records based on pivot table.
在这篇文章，为了重点说明我们在Excel12中对数据透视表作出的改变，我创建一个数据透视表作为例子。
In this post, I would like to walk through an example of creating a PivotTable in order to highlight the changes we have made in Excel 12.
还是那句话，我应该带你欣赏几个不是默认风格的数据透视表范例，或者我尝试使用“明、中、暗”各种风格的不同形式创建数据透视表。
With that said, I wanted to leave you with some examples of PivotTables formatted with different default styles. Again, I have tried to use a few of each of the Light, Medium, and Dark styles.
此报表基于一个数据透视表，该数据透视表显示最近四周内为问题捕获的数据以及存储在数据仓库中的数据。
This report is based on a PivotChart report that shows the last four weeks of data that is captured for Issues and that is stored in the data warehouse.
单击“数据查询/数据透视表”工具栏上的“数据透视表字段”按钮，可自行设置数据透视表。
To customize a pivot table, you can use the PivotTable Field button on the Query And Pivot toolbar.
您也可以通过工作项列表创建数据透视表和数据透视图报表。
You can also create PivotTable and PivotChart reports from a list of work items.
有了这些改进，数据透视表可以作为一个强大的数据研究，突出趋势，发现突出者，等等的工具来使用了。
With these improvements, PivotTables can now be used as a great tool for exploring data, highlighting trends, spotting outliers, etc.
有了这些改进，数据透视表可以作为一个强大的数据研究，突出趋势，发现突出者，等等的工具来使用了。
With these improvements, PivotTables can now be used as a great tool for exploring data, highlighting trends, spotting outliers, etc.
应用推荐