Changes

==== Working with Pivot tables ====

==== Working with Pivot tables ====

The pivot table (formerly known as DataPilot) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports. A table that has been created as a pivot table is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.

The pivot table (formerly known as Data Pilot) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports. A table that has been created as a pivot table is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.

<gallery mode="packed" heights="250px" caption="Working with Pivot tables">  

<gallery mode="packed" heights="250px" caption="Working with Pivot tables">  

File:1. LO Calc Pivot 1. data sheet.png|Data sheet

File:1. LO Calc Pivot 1. data sheet.png|Data sheet

If the button is dropped in the '''Data Fields''' area it will be given a caption that also shows the formula that will be used to calculate the data. <br>

If the button is dropped in the '''Data Fields''' area it will be given a caption that also shows the formula that will be used to calculate the data. <br>

* By double-clicking on one of the fields in the '''Data Fields''' area you can call up the [[Vnd.sun.star.help://scalc/text/scalc/01/12090105.xhp?Language=en-US&System=UNIX&UseDB=no&DbPAR=scalc|'''Data Field''']] dialog.

* By double-clicking on one of the fields in the '''Data Fields''' area you can call up the [[Vnd.sun.star.help://scalc/text/scalc/01/12090105.xhp?Language=en-US&System=UNIX&UseDB=no&DbPAR=scalc|'''Data Field''']] dialog.

*[[File:Insert data, row and column fields.png|left|800x800px|Insert data, row and column fields]]Use the '''Data Field''' dialog to select the calculations to be used for the data. To make a multiple selection, press the Ctrl key while clicking the desired calculation.{{Clear}}

*Use the '''Data Field''' dialog to select the calculations to be used for the data. To make a multiple selection, press the Ctrl key while clicking the desired calculation.[[File:Insert data, row and column fields.png|1366x1366px|Insert data, row and column fields|right]]{{Clear}}

==== Printing a spreadsheet ====

==== Printing a spreadsheet ====