As you are working with your Pivot Table in your dashboard, you may decided that you would like to edit the configurations of the Pivot Table itself.

 

1. Select the Table you would like to edit.

 

2. Navigate to the contextual Design tab in the Ribbon.

 

3. From the data group select the Edit Columns button and edit the necessary options.

 

Figure 1: The Edit Columns button is highlighted in the Ribbon.

 

To learn more about the configuration options for the Pivot Table Widget visit Insert a Pivot Table.

 

Next Steps

Row Groups - Learn about the options you have to edit the table row groups.

Header - Learn about the options you have to edit the table headers.

Totals -

Caption - Learn how to customize the Pivot Table caption to meet your needs.

Widget by Marking - Learn how to use marking to relate your inserted widgets.

Filter by Marking - Learn how to configure your widgets to filter depending on the markings you have set.

Advance Chart Options- Learn about the advance options you can use to customize your chart.

Adding Java Script - Learn how to add javascript to your Charts.