Allowing end users to configure the table layout

You can configure the Pivot Table to allow end users to change the layout.

On the Table Layout tab of the Pivot Table edit view, to allow end users to change the layout, check the Enable Pivot Table configuration by end users checkbox.

Checkbox on the Table Layout tab of the Pivot Table edit view to enable end user configuration