pivottable
美 
英
例句
The only real difference between the PivotTable and Table Styles is with regards to the number of elements in a PivotTable style.
数据透视表与列表的风格真正的区别仅仅是，可用的元素的数量多少。
If your PivotTable report is in indented format , move at least one field to the column area before you create the chart .
如果数据透视表为缩进格式，那么在创建图表前，至少要将一个字段移到列区域。
Instead , you can simply select the fields that you want to see in a new PivotTable field list .
现在，您只需在新的数据透视表字段列表中选择要查看的字段即可。
Refer to this diagram to see where the PivotTable control displays a particular element.
参考这个图表可以得知透视表控件中各元素的所在位置。
Each KPI component can be added to the PivotTable Values area by checking the checkbox just like any other field.
每个KPI成员可以通过勾选复选框添加到数据透视表数值区域，正如其它字段一样。
PivotTable views enable you to quickly reorient your data to help you answer multiple questions.
使用数据透视表视图，可以迅速重新定位数据以便帮助您回答多个问题。
Page fields allow you to filter the entire PivotTable report to display data for a single item or all the items.
页字段允许您筛选整个数据透视表，以显示单个项或所有项的数据。
As you click more non-numeric fields, Excel places them on the inside of fields already on the PivotTable, building a hierarchy.
当你点击多个非数值型字段时，Excel会自动把这些字段安排在数据透视表的字段区域当中，并建立层次结构。
As you add fields to the Values area of the PivotTable, the formatting is done automatically.
当你添加字段到数据透视表的数值区域时，格式会自动完成。
That's it for today. We would love to hear your feedback. Tomorrow, PivotTable styles.
今天就介绍到这里。我们将乐意听到您的反馈意见。明天，介绍数据透视表的样式。
Find the answers you need faster and create and use PivotTable views more easily by dragging fields where you want them to be displayed.
将字段拖动到要显示的位置，即可更快地找到所需答案、更轻松地创建和使用数据透视表视图。
With Excel 2003 PivotTable charts, I can easily convert a large amount of data into a valuable tool for analyzing sales trends.
使用Excel2003数据透视表图表，我可以轻松地将大量数据转换到有价值的工具中，以便分析销售趋势。
Only one subtotal per row area, column area, or page area can be entered in a PivotTable reference.
在数据透视表中每个行区域、列区域或页区域只能有一个分类汇总。
To lay out a PivotTable report, you drag fields from the field list window and drop them onto the drop areas.
若要调整数据透视表的布局，请从字段列表窗口拖动字段并将其放置到拖放区域。
A PivotTable report is an interactive table that you can use to quickly summarize large amounts of data.
数据透视表是一个可以用于快速汇总大量数据的交互式表格。
Even if you turned off the asterisks marking totals in Excel, the asterisks are displayed in the PivotTable list on the Web.
即使在Excel中关闭了标记汇总的星号，星号也仍会显示在网站上的数据透视表列表中。
Select this check box to enable filtering of a cell range, Excel Table, and PivotTable report, and to enable outlining.
如果选中此复选框，则允许对单元格区域、Excel表和数据透视表进行筛选，并允许分级显示。
In a PivotTable or PivotChart report, each dimension becomes a set of fields where you can expand and collapse detail.
在数据透视表或数据透视图中，每个维成为可展开和折叠明细数据的一组字段。
Users can view the PivotTable list in a Web browser and change its layout in a manner similar to an Excel PivotTable report.
用户可以在Web浏览器中查看数据透视表列表，还可以使用类似于Excel数据透视表的方式更改其布局。
Use this property to make the PivotTable control display the total captions as row headings instead of column headings.
使用这个属性来使透视表控件将行标题显示为合计值的标题，而不是列标题。
Gets or sets a value that indicates whether the PivotTable field list can be shown.
获取或设置一个值，该值指示数据透视表字段列表是否能够显示。
Determines the types of PivotTable views and PivotChart views that you see.
决定您所查看的“数据透视表”视图和“数据透视图”视图的类型。
Select this check box to enable sorting of a cell range, Excel Table, and PivotTable report.
如果选中此复选框，则允许对单元格区域、Excel表和数据透视表进行排序。
In a PivotTable report, each column or field in your source data becomes a PivotTable field that summarizes multiple rows of information.
在数据透视表中，源数据中的每列或字段都成为汇总多行信息的数据透视表字段。
In your Microsoft Excel worksheet, select the columns and rows that contain the data that you want to use to create a PivotTable report.
在您的MicrosoftExcel工作表中，选择要用于创建数据透视表的数据所在的行和列。
"Tooltips on cells" controls whether tooltips are displayed when hovering over cells inside the PivotTable row, column and values areas.
“单元格工具提示”控制当鼠标停留在数据透视表的行、列及值区域里的单元格上面时是否显示工具提示。
A PivotTable report is an interactive table that quickly combines and compares large amounts of data.
数据透视表是交互式报表，可快速合并和比较大量数据。
This procedure doesn't apply to a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component.
该过程不适用于MicrosoftOffice数据透视表组件、电子表格组件或图表组件。
The underlying rows or database records that provide the data for a PivotTable report.
为数据透视表提供数据的基础行或数据库记录。
Names associated with a PivotTable report are changed to "Author"
与PivotTable（数据透视表）报表相关联的姓名更改为“作者”。
A format used by the Microsoft Office Excel 2003 spreadsheet programs for a PivotTable report.
MicrosoftOfficeExcel2003电子表格程序中的数据透视表使用的格式。
And changing the layout of a PivotTable is also much easier to do in the new user interface.
而且，在新的用户界面中更改数据透视表的布局也更加容易。
Clear this check box to prevent filtering of a cell range, Excel Table, and PivotTable report, and to prevent outlining.
如果清除此复选框，则阻止对单元格区域、Excel表和数据透视表进行筛选，并阻止分级显示。
A PivotTable report is an interactive table that quickly combines and compares data.
数据透视表是一个交互式表格，它可以快速地组合和比较数据。
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分别具有一个工作簿。
You can reduce the amount of space a PivotTable report needs by dragging some row or column fields to the page field drop area.
要减少数据透视表所需的空间，可以将某些行或列字段拖动到页字段的拖放区域。
Expand or collapse levels of data and use a report filter in a PivotTable report.
在数据透视表中展开或折叠各级数据并使用报表筛选。
And now the PivotTable no longer contains the subtotals for Mountain Bikes and Road Bikes.
现在透视表不再包括山地自行车和公路自车的分类汇总项目。
The PivotTable report now shows the largest sales at the top (Dairy Products).
现在数据透视表在顶部显示最高销售额（点心）。
One of the goals we had for our PivotTable work in Excel 12 was to make creating PivotTables a much more approachable task.
让用户很方便、很直观的创建数据透视表是我们的一个目标，我们已经在Excel12中实现了这个目标。
