1、At the top are the PivotTable menu and some toolbar buttons to control the depth of the table.
頂部是PivotTable菜單和一些用于控制表深度的工具欄按鈕。

2、You can replicate the format of PivotTable and PivotChart views in a form.
可以復(fù)制窗體的數(shù)據(jù)透視表視圖和數(shù)據(jù)透視圖視圖的格式。

3、This is going to be the last PivotTable post, at least for a while.
這是本階段內(nèi)最后一篇關(guān)于透視表的文章了。

4、The data range you have selected includes a PivotTable report.
選定的數(shù)據(jù)區(qū)域包括一張數(shù)據(jù)透視表報(bào)表。

5、Report filter. This area holds the fields that the whole PivotTable is filtered by.
報(bào)告篩選。這個(gè)區(qū)域保留整個(gè)數(shù)據(jù)透視表未被使用的字段。

6、The Excel pivot table was correctly created so a PivotTable toolbar displays over the window.
Excelpivot表已正確創(chuàng)建，所以窗口上顯示一個(gè)PivotTable工具欄。

7、References to subtotals and data items cannot be entered into PivotTable formulas.
在透視表公式中不能輸入對(duì)分類(lèi)匯總和數(shù)據(jù)項(xiàng)的引用。

8、Replace crosstab table with PivotTable report ignoring criteria range.
用數(shù)據(jù)透視表報(bào)表替換交叉表，忽略條件范圍。

9、Only one field name may be included in a PivotTable reference
在透視表引用中只能包含一個(gè)字段名。

10、And now the PivotTable no longer contains the subtotals for Mountain Bikes and Road Bikes.
現(xiàn)在透視表不再包括山地自行車(chē)和公路自車(chē)的分類(lèi)匯總項(xiàng)目。

11、The form opens in PivotTable view.
窗體在數(shù)據(jù)透視表視圖中打開(kāi)。

12、The Refresh Data operation changed the PivotTable report.
“更新數(shù)據(jù)”操作更改了數(shù)據(jù)透視表報(bào)表。

13、Only one subtotal per row area, column area, or page area can be entered in a PivotTable reference.
在數(shù)據(jù)透視表中每個(gè)行區(qū)域、列區(qū)域或頁(yè)區(qū)域只能有一個(gè)分類(lèi)匯總。

14、This is done in the Report Layout drop down on the PivotTable Styles TAB.
這個(gè)命令已經(jīng)設(shè)置在數(shù)據(jù)透視表樣式標(biāo)簽的報(bào)告布局的下拉列表里。

15、For more complex data layouts, you can use the PivotTable system.
對(duì)于更加復(fù)雜的數(shù)據(jù)布局，您可以使用PivotTable系統(tǒng)。

16、PivotTable view: A view that summarizes and analyzes data in a datasheet or form.
數(shù)據(jù)透視表視圖：用于匯總并分析數(shù)據(jù)表或窗體中數(shù)據(jù)的視圖。

17、To illustrate, here is the PivotTable I've been using for other examples today.
舉例，這兒是今天我們?cè)谄渌右呀?jīng)使用過(guò)的透視表。

18、Say you have the following PivotTable and you want to display all the available details for Canada.
比方說(shuō)你有下面這樣的透視表，你想顯示所有“加拿大”有用的細(xì)節(jié)。

pivottable翻譯