透视表

Opens a submenu to create or edit a pivot table. A pivot table provides a summary of large amounts of data. You can then rearrange the pivot table to view different summaries of the data.

要访问此命令...

From the menu bar:

选择「数据 - 透视表」。

数据透视表

Insert or Edit

Opens a dialog where you can select the source for your pivot table, and then create or edit your table.

刷新

更新透视表。

删除

删除选中的 DataPilot 表格。

Formatting Pivot Tables