Pivot tables are used for structured data output and calculation of the total values. The PivotTable is used for the creation of pivot tables. The DataSource property sets the data source for the pivot table.

The Layout property sets the rows and columns values of the result table. The property can be edited in Sources Fields.

The list of fields from data source is displayed on the left of the Source fields’ area. The DataCube fields section is intended for data assignment in the pivot table. The fields of the table horizontal headline are set in X dimension fields list. The fields of the table vertical headline are set in Y dimension fields list. The Facts fields list includes fields for the cells with data. Property Grid is located to the left. It is used to set cells properties.

Add Feedback