數據透視表的英文

重點詞匯

數據透視表───PivotTable report

雙語使用場景

Refresh Data operation changed the PivotTable report.───更新數據”操作更改了數據透視表報表。

The data range you have selected includes a PivotTable report.───選定的數據區域包括一張數據透視表報表。

Replace crosstab table with PivotTable report ignoring criteria range.───用數據透視表報表替換交叉表，忽略條件范圍。

If your PivotTable report is in indented format , move at least one field to the column area before you create the chart .───如果數據透視表為縮進格式，那么在創建圖表前，至少要將一個字段移到列區域。

Page fields allow you to filter the entire PivotTable report to display data for a single item or all the items.───頁字段允許您篩選整個數據透視表，以顯示單個項或所有項的數據。

To lay out a PivotTable report, you drag fields from the field list window and drop them onto the drop areas.───若要調整數據透視表的布局，請從字段列表窗口拖動字段并將其放置到拖放區域。

英語使用場景

A PivotTable report cannot overlap another PivotTable report.

The Refresh Data operation changed the PivotTable report.

You cannot change, move a part of, or insert cells in a PivotTable report.

Averages, standard deviations, and variances are not supported when a PivotTable report has calculated items.

To customize a PivotTable report , you can use the PivotTable Field button on the PivotTable toolbar.