Example of Pivot Table

Data summarization method used in spreadsheets. Pivot tables can extract and create secondary tables using the data from the original to summarize information. The pivot table produces a functional response to data needs, as distinct from the "number crunching" of raw figures, breaking down figures into headings and producing easily usable and findable information.

Demographics: Population figures from different areas are summarized into age categories, rather than their original local bases, so age groups can be analyzed. Statistics will be added and translate into "X per cent of the population is over 50" using spreadsheet functions.