You can change the data that is displayed in a pivot table, show or hide columns, and make other customizations.
Required Editions
| Available in: Intelligence Reports and Intelligence Reports Advanced |
| User Permissions Needed | |
|---|---|
| To save, edit, and delete pivot tables | Create & Edit |
- In Analytics Builder, select Intelligence Reports.
- On the Pivots Tables tab, select the pivot table that you want to change and click Edit.
- To hide a dimension or measurement, in the Pivot Table Settings window, hover over the field name and click the eye icon.
- To delete a field, click X.
- To add or change data, click the + icon.
- To hide the column or row totals in the pivot table, click Options next to Columns or Rows and deselect the checkbox.