Modify Pivot Table Rows

To modify pivot table rows:

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

  2. If you are editing the visual in a dashboard, select Edit Visual 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 rows in the pivot table:

    • Select in the Rows 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 of 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 row fields are selected, select Apply.

    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.

  5. If your pivot table displays a lot of data horizontally, you may need to unfreeze the horizontal scroll bar. By default, this scroll bar is frozen. To unfreeze the horizontal scroll bar, slide the Freeze Rows slider in the Rows section of the Pivot Table Settings sidebar to the left (off). The horizontal scroll bar will appear and be useable.

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

  7. Save the dashboard.