(v24) Modify Pivot Table Columns and Column Widths

Modify Pivot Table Columns and Column Widths

This applies to: Visual Data Discovery

You can modify the columns used for a pivot table.

Adjust pivot table columns

1. Edit the pivot table you want to modify. See Edit Visuals.

2. If you are editing the visual in a dashboard, select Settings from the visual drop-down menu. The sidebar menu for the visual appears.

   If you are editing the visual from the Visual Gallery, the sidebar appears to the right of the visual.

3. Select on the sidebar menu. The Pivot Table Settings sidebar for the visual appears.

   

4. To modify the columns in the pivot table:

   • Select in the Columns area of the Pivot Table Settings sidebar. The sidebar changes to show all the possible rows for the table.

   • Select the rows you want to add and clear the ones you want to remove. If you want to select all the rows, select Select All.

     Use the search bar to search for a field in the table. Use the buttons under the search bar to limit the fields you see in the list.

     

     Select	To
     	See all available fields.
     	Limit the field list to the available attributes.
     	Limit the field list to the available numeric metrics.
     	Limit the field list to the available date and time fields.

   • After all column fields are selected, select Apply.

   Note: If the field you select is a time field, you can modify its granularity and indicate whether or not blanks (even time intervals) should be included in the time field values.
   Note: For hierarchical columns, you can show or hide rollup options by enabling or disabling Show Rollup Labels.

5. Select Apply to apply your changes to the pivot table.

6. Optionally enlarge or decrease the size of pivot table columns while the table is open for viewing.

   To change the column widths of a pivot table, drag the separator between two columns in the appropriate direction, or select Autosize All Columns from the menu in any header.

   After you save the dashboard or visual, your customized column widths are saved.

7. You may want to control whether the Totals column appearing in the rightmost column of the table is frozen on the page (not affected by horizontal scrolling) or unfrozen (only visible when you have scrolled all way to the right).

   By default, the Totals column is frozen on the pivot table (it appears regardless of scrolling actions). To unfreeze the Totals column, slide the Freeze Rows slider in the Columns section of the Pivot Table Settings sidebar to the left (off The Totals column will no longer be visible unless you scroll the table all the way to the right.

8. Save the dashboard.