File:Insert data, row and column fields.png|Insert data, row and column fields
File:Insert data, row and column fields.png|Insert data, row and column fields
+
File:Revising the data pilot for a new table.png|Revising_the_data_pivot_for_a_new_table
</gallery>
</gallery>
+
{{Clear}}
+
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 '''Data Field''' dialog.
* By double-clicking on one of the fields in the '''Data Fields''' area you can call up the '''Data Field''' dialog.
* 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.
* 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.
−
<gallery mode="packed" heights="250">
−
File:Revising the data pilot for a new table.png|Revising_the_data_pivot_for_a_new_table