pivottable

pivottable

1. another pivottable

[计] 其他数据透视表

2. create pivottable from data in

[计] 创建数据透视表数据源

3. pivottable name

[计] 数据透视表名称

4. pivottable wizard

[计] 数据透视表向导

5. pivottable field

[计] 数据透视表字段

6. scenario pivottable

[计] 数据透视表方案

7. pivottable starting cell

[计] 数据透视表显示位置

8. pivottable options

[计] 数据透视表选项

9. pivottable add

[计] 添加数据透视表

10. “Tooltips on cells” controls whether tooltips are displayed when hovering over cells inside the PivotTable row, column and values areas.

“单元格工具提示”控制当鼠标停留在数据透视表的行、列及值区域里的单元格上面时是否显示工具提示。

11. The Refresh Data operation changed the PivotTable report.

“更新数据”操作更改了数据透视表报表。

12. Once the conditional formatting is applied, I can interact with the PivotTable and the formatting will be reevaluated dynamically (as I mentioned above).

一旦应用了条件格式，我可以和该数据透视表相互交流并且该格式将会动态地被重新计算（正如我在上面提到的）。

13. 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.

上面的截图表明，新的紧凑形式的最大优点就是数据透视表能够充分利用空间，更易于阅读。

14. Here is a screenshot of the dialog illustrating how to change the data source of a PivotTable based on an OLAP data source.

下面是对话框的一个截图，举例说明怎样改变一个基于OLAP数据源的数据透视表的数据源。

15. Un-checking a checkbox will remove the field from the PivotTable.

不勾选复选框的话，这些字段就会从数据透视表中移除。

16. And a page break falls within a group of row field items (item: A subcategory of a field in PivotTable and PivotChart reports.

且分页符落在一组行字段项(项:数据透视表和数据透视图中字段的子分类。

17. and the items of the Product Category field are immediately added to the PivotTable.

产品种类字段的项目就会立即添加到数据透视表中。

18. That's it for today. We would love to hear your feedback. Tomorrow, PivotTable styles.

今天就介绍到这里。我们将乐意听到您的反馈意见。明天，介绍数据透视表的样式。

19. Today I wanted to talk about PivotTable context menus, for two reasons ... first, because we have updated them to make them more useful, and second, because we have added some neat new features that are exposed primarily in context menus.

今天我想谈一谈透视表菜单，有两个原因，首先是因为我们为其添加了一些更加有用的内容，二是因为我们增加了一些灵巧的新特色，这点在“背景菜单”中主要被显露出来。

20. Refresh: Read data from an external data connection (or all of the workbook's connections) and refresh the values in the relevant cells, e.g. in PivotTable cells or in the results of cube formulas.

从外部数据连接(或所有工作薄连接中)读取数据，并且更新相关单元格的值，例如，数据透视表单元格或三维公式的结果。

21. 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.

从本质上讲，这是相同的命令，除非当你使用这个命令时，我们知道你想把你正在操作的列表作为数据透视表的源数据。

22. Analyzing sales data with Excel 2003 PivotTable charts is a snap.

使用Excel 2003数据透视表图表可以轻而易举地分析销售数据。

23. Add a new total field for the selected field in the PivotTable view by using the Average summary function

使用“平均值”汇总函数为数据透视表视图中的选定字段添加新的汇总字段

24. Add a new total field for the selected field in the PivotTable view by using the Sum summary function

使用“总计”汇总函数为数据透视表视图中的选定字段添加新的汇总字段

25. Add a new total field for the selected field in the PivotTable view by using the Variance summary function

使用“方差”汇总函数为数据透视表视图中的选定字段添加新的汇总字段

26. Add a new total field for the selected field in the PivotTable view by using the Variance Population summary function

使用“方差总体”汇总函数为数据透视表视图中的选定字段添加新的汇总字段

27. Add a new total field for the selected field in the PivotTable view by using the Standard Deviation summary function

使用“标准偏差”汇总函数为数据透视表视图中的选定字段添加新的汇总字段

28. Add a new total field for the selected field in the PivotTable view by using the Standard Deviation Population summary function

使用“标准偏差总体”汇总函数为数据透视表视图中的选定字段添加新的汇总字段

29. Add a new total field for the selected field in the PivotTable view by using the Count summary function

使用“计数”汇总函数为数据透视表视图中的选定字段添加新的汇总字段

30. PivotTable reports enable you to spend more time analyzing the data and less time fiddling with it.

使用数据透视表,您可以有更多的时间来分析数据,而只花较少的时间来整理数据。

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

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

32. Use this property to make the PivotTable control display the total captions as row headings instead of column headings.

使用这个属性来使透视表控件将行标题显示为合计值的标题，而不是列标题。

33. Once again, we are interested to hear from the PivotTable users out there ... do these look good, or are there things you would like to see us change?

再次，我们对数据透视表用户反馈的意见很感兴趣，我们希望看到反馈，或者告诉我们您希望我们做出哪些改进？

34. Create a PivotTable or PivotChart view more easily by using data fields to reorient data quickly to summarize and find the answers you need.

创建数据透视表视图或数据透视图更加轻松(方法是使用数据字段迅速重新定位数据),可以汇总和找到所需的答案。

35. Develop OLAP software named CCB WEBOLAP based on ActiveX technology by B/S mode using PivotTable services in Analysis Services.

利用Analysis Services的数据透视表服务开发基于ActiveX以B/S方式访问的联机分析软件CCB WEBOLAP。

36. A PivotTable report that has more than one row field has one inner row field (Sport, in the example below), the one closest to the data area.

包含多个行字段的数据透视表具有一个内部行字段(下例中的“运动”),它离数据区最近。

37. You can use the Refresh Data button on the PivotTable toolbar as a shortcut for the Refresh Data command.

单击“数据透视表”工具栏上的“刷新数据”按钮，可以刷新数据透视表上的值。

38. To create an interactive PivotTable, you can use the PivotTable Wizard button on the PivotTable toolbar.

单击“数据透视表”工具栏上的“数据透视表向导”按钮，以交互方式建立一份数据透视表。

39. Fully interactive, data-bound spreadsheets including charts, tables, and PivotTable views can be created as part of a portal, dashboard, or business scorecard, without requiring any development.

可以在创建门户、仪表板或业务记分卡的过程中创建完全交互的、与数据绑定的电子表格(包括图表、表格和数据透视表视图),而无需进行任何开发。

40. You can replicate the format of PivotTable and PivotChart views in a form.

可以复制窗体的数据透视表视图和数据透视图视图的格式。

41. Again, the user didn't have to do anything but add the fields to the PivotTable to get server defined conditional formatting based on centralized business rules.

同样，用户不必做任何事情，只是添加该字段到数据透视表，以获取服务器基于集中的业务规则定义的条件格式而已。

42. In PivotTable Service, the PASSTHROUGH option is part of the INSERT INTO statement.

在PivotTable Service中,PASSTHROUGH选项是INSERT INTO语句的一部分。

43. In the PivotTable below I'm looking at sales for different bike models, and I have arranged my report so that I have a column with sales data for each year.

在下面的数据透视表里，我在看不同型号自行车的销售情况，我已经做好了我的报告，其中一列是每年的销售数据。

44. When using an OLAP data source, the PivotTable control creates a fieldset for each hierarchy in the hypercube.

在使用OLAP数据源时，透视表控件为超立方体中的每个层创建一个字段集。

45. To create a PivotTable report, you must use data that is organized as a list with labeled columns.

在创建透视表时，必须使用组合为带有标志列列表的数据。

46. In step 2 of the wizard, click the PivotTable report, so that the reference in the Data range box expands to include the entire report.

在向导的第2步中,单击透视表报表,这样“数据区域”框中的引用可展开以包括整个报表。

47. After I have made this selection, the PivotTable will now show the conditional formatting in all cells showing sales for an individual product category and an individual year.

在我做此选择之后，数据透视表在所有显示具体产品和具体年份销售数据的单元格上显示条件格式了。

48. When working with a tabular data source, the PivotTable control can display the detail data behind any aggregate by expanding the aggregate cell and showing the detail rows in place.

在操作表列数据源时，透视表控件能够通过展开一个合计单元，并立刻显示相关的细目行的方式来显示隐藏的细目数据。

49. In a PivotTable report, each column or field in your source data becomes a PivotTable field that summarizes multiple rows of information.

在数据透视表中,源数据中的每列或字段都成为汇总多行信息的数据透视表字段。

50. There are four areas in a PivotTable, each of which is represented by a drop zone in the field list.

在数据透视表中有四个区域，在字段列表中每一个区域代表一个拖拽区域。

51. In this article, you'll use data in the Pivot Table Products sample datasheet to create a PivotTable report of all product sales by quarter.

在本文中,您将使用产品数据透视表示例数据表中的数据创建一个数据透视表,按季度列出所有产品的销售额。

52. 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.

在这篇文章，为了重点说明我们在Excel12中对数据透视表作出的改变，我创建一个数据透视表作为例子。

53. Only one field name may be included in a PivotTable reference.

在透视表引用中只能包含一个字段名。

54. After the PivotTable component is connected to the OLAP data source, it can display all the hierarchies and measures in the specified hypercube through the PivotTable Field List window.

在透视表组件连接到OLAP数据源后，它可以通过透视表字段列表窗口在一个指定的超立方体中显示所有的层和尺寸。

55. Excel VBA based dynamic PivotTable technology could meet the needs of daily accountancy and supplement the lack of the function of statistics, analysis and summary in third party hospital financial software.

基于Excel VBA的动态数据透视表技术可满足日常会计工作需求,从而弥补了第三方医院财务软件统计、分析、汇总等功能之不足。

56. If your PivotTable report is in indented format, move at least one field to the column area before you create the chart.

如果数据透视表为缩进格式,那么在创建图表前,至少要将一个字段移到列区域。

57. When you have multiple row fields (row field: A field that's assigned a row orientation in a PivotTable report.

如果有多个行字段(行字段:数据透视表中按行显示的字段。

58. Clear this check box to prevent sorting of a cell range, Excel Table, and PivotTable report.

如果清除此复选框,则阻止对单元格区域、Excel表和数据透视表进行排序。

59. To hide items in a PivotTable, double-click the field button of the field that contains the items you want to hide, and then select the items in the Hide Items box.

如果要想隐藏数据透视表中的某些数据项，请先进行选定，然后选择“数据”菜单中的“数据透视表字段”命令，在“隐藏项”列表框中选定所要隐藏的数据项。

60. If you are changing the name of a PivotTable field, you must type a new name for the field.

如果要更改数据透视表字段的名称，必须键入字段的新名称。

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

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

62. To lay out your report, drag fields from the PivotTable toolbar to the marked worksheet areas.

如要布置报表，可将字段从数据透视表工具栏拖到已标示的工作表区域。

63. Turn subtotals and grand totals on or off for the selected field in the PivotTable view

对数据透视表视图中的选定字段打开或关闭小计和总计

64. Move the selected row or column field in the PivotTable view to a lower level

将数据透视表视图中的选定行或列字段移到更低级别

65. Set this to a valid connection string to hook up the PivotTable control to the data source.

应将这个属性设置为一个有效的连接字符串，可使透视表控件连接到数据源上。

66. Toggle forward between views when in a table, query, form, report, page, PivotTable list, PivotChart report, stored procedure, or Access project (. Adp) function.

当位于表、查询、窗体、报表、页、数据透视表列表、数据透视图、存储过程或Access项目(.adp)函数中时,向前切换视图。

67. Toggle back between views when in a table, query, form, report, page, PivotTable list, PivotChart report, stored procedure, or. Adp function.

当位于表、查询、窗体、报表、页、数据透视表列表、数据透视图报表、存储过程或.adp函数中时,在视图间执行向后切换。

68. When you are done arranging fields, you press the Update button, and the PivotTable does one and only one update.

当你完成字段的安排后，你按下更新按钮，数据透视表就会执行一次，仅仅一次更新。

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

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

70. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.

当希望单独查看图表或数据透视图(独立于工作表数据或数据透视表)时,图表工作表非常有用。

71. When this checkbox is checked, the “Update” button next to it becomes enabled, and now you can add, remove and move fields around without the PivotTable updating itself.

当该复选框被勾选上时，旁边的“Update”按钮就会被激活，现在你就可以添加，删除已经移动字段，而数据透视表不会自己更新了。

72. When using an OLAP data source, the PivotTable control creates a fieldset for each hierarchy in the hypercube.Some OLAP databases allow you to define multiple hierarchies for a single dimension.

您只能将汇总字段放在透视表控件的数据区域（中央区域）中，它们一般用来生成透视表报表中的所有数值。

73. 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.

成员属性也可以添加到数据透视表本身内部，当你需要打印该信息或者只是想让它时时可见。

74. One of our goals while designing the PivotTable component was to make the user interface and programming model consistent between tabular and multidimensional data sources.

我们设计透视表组件的目的之一，就是使表列数据源和多维数据源的用户界面和编程模型保持一致。

75. I will cover the first two (AutoFilter and Sort) in posts this week and PivotTables in a few weeks when I review all our PivotTable work.

我将在本周发贴谈到前两个问题（自动筛选与排序），数据透视表将在几周后我收到我们所有的资料后谈到。

76. Or column fields (column field: A field that's assigned a column orientation in a PivotTable report.

或列字段(列字段:数据透视表中按列显示的字段。

77. Report Filter. This area holds the fields that the whole PivotTable is filtered by.

报告筛选。这个区域保留整个数据透视表未被使用的字段。

78. The pointer drags the Quarter field from the PivotTable Field List to the data area.

指针将“季度”字段从“数据透视表字段列表”拖到数据区域中。

79. Keywords VBA;Excel;PivotTable;Hospital Accounting;

数据透视表;医院会计;

80. The PivotTable "|" contained incomplete information. You must refresh the PivotTable to recreate the data.

数据透视表“|”包含不完整信息。必须刷新数据透视表以调整数据。