创建数据透视表

  1. 在一个工作表中选择一个数据区域,连同行标题和列标题。

  2. Choose Insert - Pivot Table. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as buttons in the Pivot Table dialog. Drag these buttons as required and drop them into the layout areas "Filters", "Column Fields", "Row Fields" and "Data Fields".

  3. 将需要的按钮拖动到这四个区域之一。

Drag a button to the Filters area to create a button and a listbox on top of the generated pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the generated pivot table to use another page field as a filter.

如果将按钮拖放到「数据字段」区域中后,它便会获得一个标题,用来显示在数据区域中计算数据所使用的公式。

  1. 可以随时更改按钮顺序 (只要用鼠标将它们在区域内移动即可)。

  2. 您也可以将一个字段按钮重新放回原处,方法是用鼠标将它从一个区域内移到其他位置。

  3. 要打开 数据字段 对话框,请双击「行字段」或「列字段」区域的任一按钮。使用该对话框可选择「LibreOffice」是否计算显示分类汇总及其范围。

Exit the Pivot Table dialog by pressing OK. A Filter button will now be inserted, or a page button for every data field that you dropped in the Filters area. The pivot table is inserted further down.

打开文件示例:

请支持我们!