False 6 Pivot Table Layout 0 0 dialog False vertical 12 False end gtk-ok True True True True True True Saves all changes and closes dialog. True True 0 gtk-cancel True True True True Closes dialog and discards all changes. True True 1 gtk-help True True True True False True 2 True False True end 0 True False True True vertical 6 True False True True 6 True False True True 6 6 True False True True vertical 6 True False 4 Column Fields: True listbox-column 0 0 False True 0 200 100 True True True True in True True True True liststore3 False False True 0 False 0 To define the layout of a pivot table, drag and drop data field buttons onto the Page Fields, Row Fields, Column Fields, and Data Fields areas. False True 1 1 0 True False True True vertical 6 True False 4 Data Fields: True listbox-data 0 0 False True 0 240 120 True True True True in True True True True liststore4 False False True 0 False 0 To define the layout of a pivot table, drag and drop data field buttons onto the Page Fields, Row Fields, Column Fields, and Data Fields areas. False True 1 1 1 True False True True vertical 6 True False 4 Row Fields: True listbox-row 0 0 False True 0 180 100 True True True in True True True liststore5 False False True 0 False 0 To define the layout of a pivot table, drag and drop data field buttons onto the Page Fields, Row Fields, Column Fields, and Data Fields areas. False True 1 0 1 True False True True vertical 6 True False 4 Filters: True listbox-page 0 0 False True 0 200 100 True True True True in True True True True liststore1 False False True 0 False 0 To define the layout of a pivot table, drag and drop data field buttons onto the Page Fields, Row Fields, Column Fields, and Data Fields areas. False True 1 0 0 True True 0 True False True vertical 6 True False 4 Available Fields: True listbox-fields 0 False True 0 180 150 True True True True in True True True True liststore2 False False True 0 False 0 To define the layout of a pivot table, drag and drop data field buttons onto the Page Fields, Row Fields, Column Fields, and Data Fields areas. False True 1 False True 1 False True 0 True False True Drag the Items into the Desired Position False True 1 True True True True False 12 6 3 12 True Ignore empty rows True True False True 0 True Ignores empty fields in the data source. 0 0 Identify categories True True False True 0 True Automatically assigns rows without labels to the category of the row above. 1 0 Total rows True True False True 0 True Calculates and displays the grand total of the row calculation. 1 1 Total columns True True False True 0 True Calculates and displays the grand total of the column calculation. 0 1 Add filter True True False True 0 True Adds a Filter button to pivot tables that are based on spreadsheet data. 0 2 Enable drill to details True True False True 0 True Select this check box and double-click an item label in the table to show or hide details for the item. Clear this check box and double-click a cell in the table to edit the contents of the cell. 1 2 True False Options True False True 2 True True True True False 12 6 True 6 12 True False True 0 none True False 6 12 True False True 3 6 New sheet True True False True 0 True True 0 0 3 Selection True True False True 0 True destination-radio-new-sheet 0 2 True True True Select the area where you want to display the results of the pivot table. 1 2 True True True Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size. 2 2 True False Select the area where you want to display the results of the pivot table. 1 1 2 Named range True True False True 0 True destination-radio-new-sheet 0 1 True False Destination 0 1 True False True 0 none True False 6 12 True False True 3 6 Selection True True False True 0 True True 0 1 True True True True Select the area that contains the data for the current pivot table. 1 1 True True True Select the area that contains the data for the current pivot table. 2 1 Named range True True False True 0 True source-radio-selection 0 0 True False 1 0 2 True False Source 0 0 True False Source and Destination True Displays or hides additional options for defining the pivot table. False True 3 False True 1 ok cancel help Specify the layout of the table that is generated by the pivot table.