Information and Communication Technology

5.4.38 Pivot Table

A pivot table is an interactive worksheet table that can summarize large amount of existing data using the given format and calculation methods. Before creating pivot table, remove filter and subtotals.

1. Select the data series range
2. Sort the records in desired order
3. Select Pivot table in Data menu
4. Verify the selected range
5. Select the data fields such as Sum, count, Minimum, maximum, variance etc.
6. Give the row field or column field item to display details for each item in rowwise or columnwise
7. Give the pivot table range. If it is not given pivot table will be created in a new worksheet
8. Pivot table will shows the summarised data for each item and also the grand totals at end