436
edits
Changes
Jump to navigation
Jump to search
→Working with Pivot tables
Line 101:
Line 101:
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
Line 107:
Line 108:
</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 ====