The aggregations or summaries of the groups of the individual terms might include sums, averages, counts, or other statistics.
A pivot table is the outcome of the statistical processing of tabularized raw data and can be used for decision-making.
While working on a concept for a new program that would eventually become Lotus Improv, Salas noted that spreadsheets have patterns of data.
A tool that could help the user recognize these patterns would help to build advanced data models quickly.
[3] Borland purchased the DataPivot technology in 1992 and implemented it in their own spreadsheet application, Quattro Pro.
A pivot table can help quickly summarize the data and highlight the desired information.
": A pivot table usually consists of row, column and data (or fact) fields.
In this case, the column is ship date, the row is region and the data we would like to see is (sum of) units.
These fields allow several kinds of aggregations, including: sum, average, standard deviation, count, etc.
Based on the aggregation type, sum, it will summarize the fact, the quantities of Unit, and display them in a multidimensional chart.
There will be a filter above the data — column labels — from which one can select or deselect a particular salesperson for the pivot table.
There will be a filter above the data — row labels — from which one can select or deselect a particular salesperson for the Pivot table.
Programming languages and libraries suited to work with tabular data contain functions that allow the creation and manipulation of pivot tables.