Lotus Development released Improv in 1991 on the NeXT platform. This core functionality would provide the model for pivot tables. With Improv, users could define and store sets of categories, then change views by dragging category names with the mouse. A tool that could help the user recognize these patterns would help to build advanced data models quickly. While working on a concept for a new program that would eventually become Lotus Improv, Salas noted that spreadsheets have patterns of data. In their book Pivot Table Data Crunching, Bill Jelen and Mike Alexander refer to Pito Salas as the "father of pivot tables". This summary might include sums, averages, or other statistics, which the pivot table groups together using a chosen aggregation function applied to the grouped values.Īlthough pivot table is a generic term, Microsoft held a trademark on the term in the United States from 1994 to 2020. ![]() ![]() ![]() For cross-tabulation that aggregates only by counting (rather than summing, averaging, etc.), see Contingency table.Ī pivot table is a table of grouped values that aggregates the individual items of a more extensive table (such as from a database, spreadsheet, or business intelligence program) within one or more discrete categories.
0 Comments
Leave a Reply. |