Changes
From Open Educational Resources
26 bytes added
, 09:23, 25 May 2018
Line 102: |
Line 102: |
| 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. |
| | | |
| ==== Printing a spreadsheet ==== | | ==== Printing a spreadsheet ==== |