建立樞紐分析表

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 "Page Fields", "Column Fields", "Row Fields" and "Data Fields".

3. 將所需的按鈕拖曳至四個區塊之一。

Drag a button to the Page Fields 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.

如果按鈕放置於 [資料欄位] 區塊中，並且會給按鈕一個標籤同時顯示將用於計算資料的公式。

• 連按兩下 [資料欄位] 區塊中的欄位之一，您可在該區塊呼叫[資料欄位] 對話方塊。

• Use the Data Field dialog to select the calculations to be used for the data. To make a multiple selection, press the key while clicking the desired calculation.

1. 您可以使用滑鼠將按鈕移至區塊中的不同位置以隨時變更按鈕的順序。

2. 用滑鼠將欄位從區塊中移出時，就可以將這個欄位移動到其他的位置。

3. To open the Data Field dialog, double-click one of the buttons in the Row Fields or Column Fields area. Use the dialog to select if and to what extent LibreOffice calculates display subtotals.

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 Page Fields area. The pivot table is inserted further down.

Open file with example: