1,603
edits
Changes
Jump to navigation
Jump to search
Line 103:
Line 103: − Inserting pivot table from the existing data sheet:+ − + + −
→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>
# Position the cursor within a range of cells containing values, row and column headings.
# 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.
# Choose Insert - Pivot Table - Create. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as
buttons in the Pivot Table dialog.
<gallery mode="packed" heights="280px" "caption="Adding the fields">
<gallery mode="packed" heights="280px" "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.
<gallery mode="packed" heights="200px">
<gallery mode="packed" heights="200px">