436
edits
Changes
Jump to navigation
Jump to search
Line 5:
Line 5: − + Line 106:
Line 106: − + − + +
→Working with Pivot tables
=== Introduction ===
=== Introduction ===
Earlier accountants used large pieces of paper to record business finances, to enter information like costs, payments, taxes, income etc. so that they got a complete financial overview. These large paper pieces were called “spreadsheets”. The digital spreadsheet is similar, with columns and rows. A cell is a combination or intersection of a row and a column, in which information (both text and numeric) can be input. A sheet can be simply understood as an array of cells.
Earlier accountants used large pieces of paper to record business finances, to enter information like costs, payments, taxes, income etc. so that they got a complete financial overview. These large paper pieces were called “spreadsheets”. The digital spreadsheet is similar, with columns and rows. A cell is a combination or intersection of a row and a column, in which informationcaption="Working with Pivot tables" (both text and numeric) can be input. A sheet can be simply understood as an array of cells.
==== 1.1 Basic information ====
==== 1.1 Basic information ====
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>
<nowiki></gallery></nowiki>
# 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">
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:2. 6. LO Calc data pivot 6 - getting the pivot table report.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
</gallery>
</gallery>