1,603
edits
Changes
From Open Educational Resources
no edit summary
</gallery>
</gallery>
# Position the cursor within a range of cells containing values, row and column headings.
# Position the cursor within a range of cells containing values, row and column headings.
# Choose Insert - Pivot Table - Create. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as
# Choose Insert - Pivot Table - Create. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as <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 <nowiki></gallery></nowiki>
# Drag the desired buttons into one of the four areas.
<gallery mode="packed" heights="280px" "caption="Adding the fields">
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.
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
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.
</gallery>
* By double-clicking on one of the fields in the '''Data Fields''' area you can call up the [[Vnd.sun.star.help://scalc/text/scalc/01/12090105.xhp?Language=en-US&System=UNIX&UseDB=no&DbPAR=scalc|'''Data Field''']] dialog.
# Pivot Wizard: Select the desired column fields from the available fields and similarly add the row and data fields from the wizard then click ok.
* 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="200px">
<gallery mode="packed" heights="200px">
File:5. LO Calc data pivot 5 - Insert data, row and column fields.png|Insert data,row and column fields
File:5. LO Calc data pivot 5 - Insert data, row and column fields.png|Insert data,row and column fields
