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.
可以復制窗體的數(shù)據(jù)透視表視圖和數(shù)據(jù)透視圖視圖的格式。

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

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

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

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

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

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

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

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

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

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

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

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

15、For more complex data layouts, you can use the PivotTable system.
對于更加復雜的數(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.
舉例，這兒是今天我們在其他例子已經(jīng)使用過的透視表。

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

pivottable翻譯