The data and table appearance are defined with the settings on the Pivotal table settings tab.

The data source is set in the Data source field. To adjust the pivot table cells you should open Source Fields editor with the “Configure layout” button.

It is possible to set pivot table caption in the Table caption field.

The Rendering group of properties allows the setting of such properties of the PivotTable as: ShowRepeatText, ShowSingleFact, and DementionOnEveryPage.

The size of cells of the pivot table can be set in the Formatting section. It is possible to set the PivotTable.AutoColumnWidth, PivotTable.RowHeight and PivotTable.AutoRowHeight properties.

(More information about pivot table properties)

Add Feedback