PivotTable

PivotTable is the feature that creates new table with the you need. You can sort and filter data as you want with PivotTable. Use PivotTable Wizard to create your PivotTable report by summarizing and calculating data.

Note

Requirements for Source Data for Creating PivotTable

To obtain the desired information, the source data for a PivotTable must satisfy certain requirements. The basic requirements for a PivotTable's source data are as follows:

See Also