Changes
From Open Educational Resources
No change in size
, 06:59, 6 June 2022
Line 127: |
Line 127: |
| The table headings are shown as buttons in the Pivot Table dialog. Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields". <br>3. Drag the desired buttons into one of the four areas. <br> | | The table headings are shown as buttons in the Pivot Table dialog. Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields". <br>3. Drag the desired buttons into one of the four areas. <br> |
| Drag a button to the '''Page Fields''' area to create a button and a listbox on top of the generated pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the generated pivot table to use another page field as a filter. <br> | | Drag a button to the '''Page Fields''' area to create a button and a listbox on top of the generated pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the generated pivot table to use another page field as a filter. <br> |
− | <gallery mode="packed" heights="250"> | + | <gallery mode="packed" heights="200"> |
| 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 | | File:Revising the data pilot for a new table.png|Revising_the_data_pivot_for_a_new_table |