436
edits
Changes
From Open Educational Resources
→Working with Pivot tables
File:1. LO Calc Pivot 1. data sheet.png|Data sheet
File:1. LO Calc Pivot 1. data sheet.png|Data sheet
File:2. LO Calc Pivot 2. Inserting pivot.png|Inserting Pivot
File:2. LO Calc Pivot 2. Inserting pivot.png|Inserting Pivot
</gallery>Inserting pivot table from the existing data sheet:
</gallery>
Inserting pivot table from the existing data sheet:
# Inserting pivot: select the desired rows and click on Insert → Pivot Table option,you will get the select source wizard,then click on current selection.<gallery mode="packed" heights="250px" "caption="Adding the fields">
# Inserting pivot: select the desired rows and click on Insert → Pivot Table option,you will get the select source wizard,then click on current selection.<gallery mode="packed" heights="250px" "caption="Adding the fields">
File:3. LO Calc Data Pivot 3. Current Selection.png|Selection wizard
File:3. LO Calc Data Pivot 3. Current Selection.png|Selection wizard
</gallery>
</gallery>
# 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.
# 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.
<gallery mode="packed" heights="250px" caption="Working with Pivot tables">
File:5. LO Calc data pivot 5 - Insert data, row and column fields.png|Insert data,row and column fields
File:2. 6. LO Calc data pivot 6 - getting the pivot table report.png|Getting the pivot table report
</gallery>
==== Printing a spreadsheet ====
==== Printing a spreadsheet ====
