Changes
From Open Educational Resources
26 bytes added
, 18:23, 25 May 2018
Line 103: |
Line 103: |
| </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 |
Line 111: |
Line 112: |
| 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> |
| | | |