\<bookmark_value\>DataPilot function; editing tables\</bookmark_value\>\<bookmark_value\>editing;DataPilot tables\</bookmark_value\>

Editing Pivot Tables

Click one of the buttons in the table that the DataPilot has created and hold the mouse button down. A special symbol will appear next to the mouse pointer.

By dragging the button to a different position in the same row you can alter the order of the columns. If you drag a button to the left edge of the table into the row headings area, you can change a column into a row.

In the DataPilot dialog, you can drag a button to the \<emph\>Page Fields\</emph\> area to create a button and a listbox on top of the generated DataPilot table. The listbox can be used to filter the DataPilot table by the contents of the selected item. You can use drag-and-drop within the generated DataPilot table to use another page field as a filter.

To remove a button from the table, just drag it out of the DataPilot table. Release the mouse button when the mouse pointer positioned within the sheet has become a 'not allowed' icon. The button is deleted.

To edit the DataPilot table, click a cell inside the DataPilot table and open the context menu. In the context menu you find the command \<emph\>Start\</emph\>, which displays the \<emph\>DataPilot\</emph\> dialog for the current DataPilot table.

In the pivot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields.

You can assign custom display names to fields, field members, subtotals (with some restrictions), and grand totals inside pivot tables. A custom display name is assigned to an item by overwriting the original name with another name.

Open file with example: