[WEBINAR] Application Acceleration: Faster Performance for End Users

Pivot Table

Definition - What does Pivot Table mean?

A pivot table is a data processing tool used to query, organize and summarize data or information between spreadsheets, tables or databases. Dragging and dropping fields into a pivot table facilitates rotational, or pivotal, structural changes.

The generic pivot table term is used by many companies and software vendors. PivotTable, Microsoft branded and trademarked version, is used in most Excel products.

Techopedia explains Pivot Table

A pivot table is useful when analyzing a large amount of data, as it allows users to apply specific criteria to summarize, organize and reorganize data tables and create reports.

For example, when a store manager reviews the sales of a specific item over a six-month period, he must sift through many pages of relevant and irrelevant data. A pivot table, however, simplifies this process by automatically counting, summarizing and sorting data. Summarized data may then be used to create a report tailored to the item's activity within the specified six-month parameter, reducing data output and table columns and rows. This process may be used to accommodate various data requirements.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
"Techopedia" on Twitter

Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Free Whitepaper: The Path to Hybrid Cloud
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.