Your shopping cart is empty!
The pivot table
Use a PivotTable report when you want to compare related totals, especially when you have a long list of figures to summarize and you want to compare several facts about each figure. Use PivotTable reports when you want Microsoft Excel to do the sorting, subtotalling, and totalling for you.
Following steps are to be taken for creating a pivot table -