436
edits
Changes
Jump to navigation
Jump to search
Line 103:
Line 103: − + + Line 111:
Line 112: − +
→Working with Pivot tables
</gallery>
</gallery>
Inserting pivot table from the existing data sheet:
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="280px" "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="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
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
File:5. LO Calc data pivot 5 - Insert data, row and column fields.png|Getting the pivot table report
File:5. LO Calc data pivot 5 - Insert data, row and column fields.png|Getting the pivot table report
File:7. LO Calc data pivot 7 - revising the data pilot for a new table.png|Revising
File:7. LO Calc data pivot 7 - revising the data pilot for a new table.png|Revising pivot data for new table
</gallery>
</gallery>