pivottable

美 　英

• 網(wǎng)絡(luò)數(shù)據(jù)透視表；樞紐分析表；樞紐表

例句

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

數(shù)據(jù)透視表與列表的風(fēng)格真正的區(qū)別僅僅是，可用的元素的數(shù)量多少。

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

如果數(shù)據(jù)透視表為縮進格式，那么在創(chuàng)建圖表前，至少要將一個字段移到列區(qū)域。

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

現(xiàn)在，您只需在新的數(shù)據(jù)透視表字段列表中選擇要查看的字段即可。

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成員可以通過勾選復(fù)選框添加到數(shù)據(jù)透視表數(shù)值區(qū)域，正如其它字段一樣。

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

使用數(shù)據(jù)透視表視圖，可以迅速重新定位數(shù)據(jù)以便幫助您回答多個問題。

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

頁字段允許您篩選整個數(shù)據(jù)透視表，以顯示單個項或所有項的數(shù)據(jù)。

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

當(dāng)你點擊多個非數(shù)值型字段時，Excel會自動把這些字段安排在數(shù)據(jù)透視表的字段區(qū)域當(dāng)中，并建立層次結(jié)構(gòu)。

As you add fields to the Values area of the PivotTable, the formatting is done automatically.

當(dāng)你添加字段到數(shù)據(jù)透視表的數(shù)值區(qū)域時，格式會自動完成。

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

今天就介紹到這里。我們將樂意聽到您的反饋意見。明天，介紹數(shù)據(jù)透視表的樣式。

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

將字段拖動到要顯示的位置，即可更快地找到所需答案、更輕松地創(chuàng)建和使用數(shù)據(jù)透視表視圖。

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

使用Excel2003數(shù)據(jù)透視表圖表，我可以輕松地將大量數(shù)據(jù)轉(zhuǎn)換到有價值的工具中，以便分析銷售趨勢。

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

在數(shù)據(jù)透視表中每個行區(qū)域、列區(qū)域或頁區(qū)域只能有一個分類匯總。

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

若要調(diào)整數(shù)據(jù)透視表的布局，請從字段列表窗口拖動字段并將其放置到拖放區(qū)域。

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

數(shù)據(jù)透視表是一個可以用于快速匯總大量數(shù)據(jù)的交互式表格。

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

即使在Excel中關(guān)閉了標(biāo)記匯總的星號，星號也仍會顯示在網(wǎng)站上的數(shù)據(jù)透視表列表中。

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

如果選中此復(fù)選框，則允許對單元格區(qū)域、Excel表和數(shù)據(jù)透視表進行篩選，并允許分級顯示。

In a PivotTable or PivotChart report, each dimension becomes a set of fields where you can expand and collapse detail.

在數(shù)據(jù)透視表或數(shù)據(jù)透視圖中，每個維成為可展開和折疊明細數(shù)據(jù)的一組字段。

Users can view the PivotTable list in a Web browser and change its layout in a manner similar to an Excel PivotTable report.

用戶可以在Web瀏覽器中查看數(shù)據(jù)透視表列表，還可以使用類似于Excel數(shù)據(jù)透視表的方式更改其布局。

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

使用這個屬性來使透視表控件將行標(biāo)題顯示為合計值的標(biāo)題，而不是列標(biāo)題。

Gets or sets a value that indicates whether the PivotTable field list can be shown.

獲取或設(shè)置一個值，該值指示數(shù)據(jù)透視表字段列表是否能夠顯示。

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

決定您所查看的“數(shù)據(jù)透視表”視圖和“數(shù)據(jù)透視圖”視圖的類型。

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

如果選中此復(fù)選框，則允許對單元格區(qū)域、Excel表和數(shù)據(jù)透視表進行排序。

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

在數(shù)據(jù)透視表中，源數(shù)據(jù)中的每列或字段都成為匯總多行信息的數(shù)據(jù)透視表字段。

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工作表中，選擇要用于創(chuàng)建數(shù)據(jù)透視表的數(shù)據(jù)所在的行和列。

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

“單元格工具提示”控制當(dāng)鼠標(biāo)停留在數(shù)據(jù)透視表的行、列及值區(qū)域里的單元格上面時是否顯示工具提示。

A PivotTable report is an interactive table that quickly combines and compares large amounts of data.

數(shù)據(jù)透視表是交互式報表，可快速合并和比較大量數(shù)據(jù)。

This procedure doesn't apply to a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component.

該過程不適用于MicrosoftOffice數(shù)據(jù)透視表組件、電子表格組件或圖表組件。

The underlying rows or database records that provide the data for a PivotTable report.

為數(shù)據(jù)透視表提供數(shù)據(jù)的基礎(chǔ)行或數(shù)據(jù)庫記錄。

Names associated with a PivotTable report are changed to "Author"

與PivotTable（數(shù)據(jù)透視表）報表相關(guān)聯(lián)的姓名更改為“作者”。

A format used by the Microsoft Office Excel 2003 spreadsheet programs for a PivotTable report.

MicrosoftOfficeExcel2003電子表格程序中的數(shù)據(jù)透視表使用的格式。

And changing the layout of a PivotTable is also much easier to do in the new user interface.

而且，在新的用戶界面中更改數(shù)據(jù)透視表的布局也更加容易。

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

如果清除此復(fù)選框，則阻止對單元格區(qū)域、Excel表和數(shù)據(jù)透視表進行篩選，并阻止分級顯示。

A PivotTable report is an interactive table that quickly combines and compares data.

數(shù)據(jù)透視表是一個交互式表格，它可以快速地組合和比較數(shù)據(jù)。

The example PHP application builds an Excel XML file that has one worksheet for the raw data and another for the PivotTable.

示例PHP應(yīng)用程序構(gòu)建一個ExcelXML文件，其中為原始數(shù)據(jù)和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.

要減少數(shù)據(jù)透視表所需的空間，可以將某些行或列字段拖動到頁字段的拖放區(qū)域。

Expand or collapse levels of data and use a report filter in a PivotTable report.

在數(shù)據(jù)透視表中展開或折疊各級數(shù)據(jù)并使用報表篩選。

And now the PivotTable no longer contains the subtotals for Mountain Bikes and Road Bikes.

現(xiàn)在透視表不再包括山地自行車和公路自車的分類匯總項目。

The PivotTable report now shows the largest sales at the top (Dairy Products).

現(xiàn)在數(shù)據(jù)透視表在頂部顯示最高銷售額（點心）。

One of the goals we had for our PivotTable work in Excel 12 was to make creating PivotTables a much more approachable task.

讓用戶很方便、很直觀的創(chuàng)建數(shù)據(jù)透視表是我們的一個目標(biāo)，我們已經(jīng)在Excel12中實現(xiàn)了這個目標(biāo)。