1,325
edits
Changes
Jump to navigation
Jump to search
Line 121:
Line 121: − + + + + − + − + + + − Use the '''Data Field''' dialog to select the calculations to be used for the data. To make a multiple selection, press the Ctrl key while clicking the desired calculation.
→Working with Pivot tables
File:2. LO Calc Pivot 2. Inserting pivot.png|Inserting Pivot
File:2. LO Calc Pivot 2. Inserting pivot.png|Inserting Pivot
</gallery>
</gallery>
1. Position the cursor within a range of cells containing values, row and column headings. <br>2. Choose Insert - Pivot Table - Create. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as <br><gallery mode="packed" heights="280px" "caption="Adding the fields"> File:3. LO Calc Data Pivot 3. Current Selection.png|Selection wizard File:4. LO Calc Data Pivot 4. Pivot form.png|Pivot Table wizard </gallery>
1. Position the cursor within a range of cells containing values, row and column headings. <br>2. Choose Insert - Pivot Table - Create. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as <br>
<gallery mode="packed" heights="280px" "caption="Adding the fields">
File:3. LO Calc Data Pivot 3. Current Selection.png|Selection wizard
File:4. LO Calc Data Pivot 4. Pivot form.png|Pivot Table wizard </gallery>
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". <br>3. Drag the desired buttons into one of the four areas. <br>
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". <br>3. Drag the desired buttons into one of the four areas. <br>
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. <br>
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. <br>
<gallery mode="packed" heights="350">
<gallery mode="packed" heights="250">
File:Insert data, row and column fields.png|Insert data, row and column fields
File:Insert data, row and column fields.png|Insert data, row and column fields
</gallery>
</gallery>
If the button is dropped in the '''Data Fields''' area it will be given a caption that also shows the formula that will be used to calculate the data. <br>
If the button is dropped in the '''Data Fields''' area it will be given a caption that also shows the formula that will be used to calculate the data. <br>
* By double-clicking on one of the fields in the '''Data Fields''' area you can call up the '''Data Field''' dialog.
* By double-clicking on one of the fields in the '''Data Fields''' area you can call up the '''Data Field''' dialog.
<gallery mode="packed" heights="350">
* Use the '''Data Field''' dialog to select the calculations to be used for the data. To make a multiple selection, press the Ctrl key while clicking the desired calculation.
<gallery mode="packed" heights="250">
File:Revising the data pilot for a new table.png|Revising_the_data_pivot_for_a_new_table
File:Revising the data pilot for a new table.png|Revising_the_data_pivot_for_a_new_table
</gallery>
</gallery>
{{Clear}}
{{Clear}}
{{Clear}}
{{Clear}}