大家在查： Nagi Baler mutacin teenier ihjh 重严重 hunkers down NineWest 与其相连雅克•纳赛尔

透视表

网络perspective; Pivot

透视表

透视表

透视表

perspective

■1、创建透视表（perspective）并通过透视表访问Cube ■2、创建MDX查询 ■3、从Analysis Services的数据创建Excel 2007/20…

Pivot

...但却又偏偏对电子表格的Link情有独钟，可偏偏又对透视表（Pivot）嗤之以鼻，让人莫名其妙。

1

The only real difference between the PivotTable and Table Styles is with regards to the number of elements in a PivotTable style .

数据透视表与列表的风格真正的区别仅仅是，可用的元素的数量多少。

2

Under All Charts , All PivotTables, All Tables, or All Named Ranges, two or more items have been selected that have the same name .

在 “所有图表 ”、“所有数据透视表 ”、“所有表 ”或 “所有命名区域 ”下，已经选择两个或更多同名项目。

3

4

You can remove a column, row, or page field from the DataPilot simply by dragging it out of the DataPilot with the mouse .

您也可以简便地使用鼠标将一个列、行或页字段从数据透视表中通过拖拽方式移除出去。

5

Instead , you can simply select the fields that you want to see in a new PivotTable field list .

现在，您只需在新的数据透视表字段列表中选择要查看的字段即可。

6

Refer to this diagram to see where the PivotTable control displays a particular element .

参考这个图表可以得知透视表控件中各元素的所在位置。

7

Each KPI component can be added to the PivotTable Values area by checking the checkbox just like any other field .

每个 KPI 成员可以通过勾选复选框添加到数据透视表数值区域，正如其它字段一样。

8

PivotTable views enable you to quickly reorient your data to help you answer multiple questions .

使用数据透视表视图，可以迅速重新定位数据以便帮助您回答多个问题。

10

Page fields allow you to filter the entire PivotTable report to display data for a single item or all the items.

页字段允许您筛选整个数据透视表，以显示单个项或所有项的数据。

11

As you click more non-numeric fields , Excel places them on the inside of fields already on the PivotTable , building a hierarchy .

当你点击多个非数值型字段时，Excel 会自动把这些字段安排在数据透视表的字段区域当中，并建立层次结构。

12

Once the user selects one of these commands , they are presented with a new dialog for creating PivotTables.

一旦用户选择这两个命令的其中之一时，会出现一个创建数据透视表的新对话框。

15

As I said in the previous post , PivotTables are great for summarizing large amounts of data .

正如我在以前的文章中所说，数据透视表主要用于处理大量的数据。

16

Find the answers you need faster and create and use PivotTable views more easily by dragging fields where you want them to be displayed .

将字段拖动到要显示的位置，即可更快地找到所需答案、更轻松地创建和使用数据透视表视图。

17

You can read the output into a spreadsheet program like Microsoft Excel and use pivot tables to view the results .

可以将输出读入像 MicrosoftExcel 这样的电子表格程序并使用数据透视表查看结果。

18

With Excel 2003 PivotTable charts, I can easily convert a large amount of data into a valuable tool for analyzing sales trends .

使用 Excel2003 数据透视表图表，我可以轻松地将大量数据转换到有价值的工具中，以便分析销售趋势。

19

Only one subtotal per row area, column area, or page area can be entered in a PivotTable reference.

在数据透视表中每个行区域、列区域或页区域只能有一个分类汇总。

20

To lay out a PivotTable report, you drag fields from the field list window and drop them onto the drop areas .

若要调整数据透视表的布局，请从字段列表窗口拖动字段并将其放置到拖放区域。

21

A PivotTable report is an interactive table that you can use to quickly summarize large amounts of data .

数据透视表是一个可以用于快速汇总大量数据的交互式表格。

22

Even if you turned off the asterisks marking totals in Excel , the asterisks are displayed in the PivotTable list on the Web .

即使在 Excel 中关闭了标记汇总的星号，星号也仍会显示在网站上的数据透视表列表中。

24

Select this check box to enable filtering of a cell range , Excel Table, and PivotTable report, and to enable outlining .

如果选中此复选框，则允许对单元格区域、Excel 表和数据透视表进行筛选，并允许分级显示。

25

26

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 数据透视表的方式更改其布局。

27

The Pivot Table pane that appears, as shown in the following image will help you with debugging .

如下图所示的 “透视表 ”窗格将有助于您进行调试。

30

Determines the types of PivotTable views and PivotChart views that you see .

决定您所查看的 “数据透视表 ”视图和 “数据透视图 ”视图的类型。

热词推荐

大家在看