• Nature of the basic data for the pivot table
• Pivot table and chart creation
• Improved data consolidation

Deepening the possibilities

• Manual and automatic grouping of data
• Drillthrough / Drilldown – temporary data extracts
• Automatic sheet generation from report filter fields
• Multiple value fields and value field settings
• Automatic sorting of row / column fields
• Basic pivot table settings
• Pivot from multiple files

Further calculations

• User-defined calculations for data fields
• Calculated fields and elements
• Access to data with pivot data assignment

Work on the pivot diagram

• Finding the right diagram types