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">
+
# 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
File:4. LO Calc Data Pivot 4. Pivot form.png|Pivot Table wizard
File:4. LO Calc Data Pivot 4. Pivot form.png|Pivot Table 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.