PivotTables are a feature of Excel Spreadsheets that allow you to group data and perform calculations on those groups. PivotTables make it very easy to see things like sales broken down by region, sales person, etc.
PivotTables
|
Source Workbook: |
Generated Workbook: |
PivotCharts
|
Source Workbook: |
Generated Workbook: |
- Any existing PivotTables in your Source Workbook will be copied into the Generated Workbook.
- You can construct PivotTables based on inserted data ( Field Markers )
You can have multiple PivotTables in a workbook. As many as you want.
Excel 5.0/95 PivotTable Support
SpeedGen does not officially support PivotTables in Excel 5.0 / 95 format workbooks. They will work to some degree but there are just so many differences between PivotTables in the Excel 5.0 / 95 format and in the Excel 97 / 2000 / 2002 (XP) format that it is not officially supported.
The Recommended Approach
SpeedGen provides a simple, yet elegant approach to creating PivotTables:
- Create the first PivotTable using Field Markers
- Create Additional PivotTables based on the first PivotTable
- Create PivotCharts based on any PivotTable
This way you only have to specify the Source Data once and getting the Source Data is easy because you use Field Markers
Do not Refresh a PivotTable in the Source Workbook that is directly or indirectly based on Field Markers
PivotTable & PivotCharts Sample
Web Links
- PivotTable Reports 101 for Excel 2002 ( but also applies to previous versions )
- 25 Easy PivotTable Reports for Excel ( this is a great article for Excel 2002 but PivotTables in Excel 2002 are very similar to Excel 97 and 2000 PivotTables )
- Improve the Readability of an Excel 2000 PivotTable Report
