The pivot table (formerly known as DataPilot) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports.
A table that has been created as a pivot table is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.