Changes
From Open Educational Resources
26 bytes added
, 03:53, 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 ==== |