In Data Processing, What Is a Pivot Table?

Pivot Table is an interactive table that can perform certain calculations, such as summing and counting. The calculations and data are related to the arrangement in the pivot table.

You can use the "PivotTable Wizard" to create a PivotTable in Access. This wizard uses Excel to create a pivot table, and then uses Microsoft Access to create an embedded pivot table.

To create a PivotTable, run the PivotTable and PivotChart Wizard. In the wizard, select the source data from a worksheet list or an external database. The wizard then provides you with a list of worksheet areas and available fields for the report. When you drag a field from the list window to the outline area, Microsoft Excel automatically summarizes and calculates the report.

If you use Office Data Connection to retrieve external data for a report (external data: data stored outside of Excel. For example, in Access,

Pivot table cache

Every time you create a new PivotTable or PivotChart, Excel stores a copy of the report data in memory and saves it as part of the workbook file. This requires additional memory and disk space for each new report. However, if you use an existing PivotTable as the source data for a new report in the same workbook, both reports can share the same copy of the data. Because the storage area can be reused, the workbook file is reduced and the data in memory is reduced.

Location requirements

If you want to use a PivotTable as the source data for other reports, both reports must be in the same workbook. If the source PivotTable is in another workbook, you need to copy the source report to the workbook location where you want to create the new report. The PivotTable and PivotChart in different workbooks are independent, and they have their own copies of the data in memory and in the workbook file.

Changes affect both reports

When you refresh the data in the new report, Excel also updates the data in the source report and vice versa. Grouping or ungrouping items in a report will also affect both reports. If a calculated field is created in a report (Calculated Field: Field in PivotTable or PivotChart, the field uses a formula created by the user. Calculated Field can use content from PivotTable or other fields in PivotChart Perform a calculation.) Or a calculated item (calculated item: an item in a PivotTable field or PivotChart field that uses a user-created formula. A calculated item uses the contents of a PivotTable or other item in the same field in the PivotChart Calculations.), It will also affect both reports.

Pivot chart report

You can create new PivotTable or PivotChart reports based on other PivotTables, but you cannot create reports directly based on other PivotChart reports. However, whenever a PivotChart report is created, Excel creates an associated PivotTable based on the same data (Associated PivotTable: A PivotTable that provides the source data for the PivotChart. In the new PivotChart The pivot table is created automatically when you change the layout of one of the reports, and the other also changes.); Therefore, you can create a new report based on the associated report. Changes made to the PivotChart report will affect the associated PivotTable and vice versa. ^[2]