1,325
edits
Changes
Jump to navigation
Jump to search
Line 129:
Line 129: + + + − <gallery mode="packed" heights="250"> − File:Revising the data pilot for a new table.png|Revising_the_data_pivot_for_a_new_table − </gallery> − {{Clear}}
→Working with Pivot tables
<gallery mode="packed" heights="250">
<gallery mode="packed" heights="250">
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.
{{Clear}}
{{Clear}}