Pivot Table
2 Answer(s)
Maria
In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, a pivot-table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a "pivot table") showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations. The user sets up and changes the summary's structure by dragging and dropping fields graphically. This "rotation" or pivoting of the summary table gives the concept its name.
Jan 10 2014 03:48 PM
Binny
A pivot table is a data summarization tool that can be used to summarize, analyze, explore and present your data.
SOME USES OF PIVOT TABLES:
1) Summarizing data like finding the average sales for each region for each product from a product sales data table.
2) Listing unique values in any column of a table.
3) Creating a pivot report with sub-totals and custom formats.
4) Making a dynamic pivot chart.
5) Filtering, sorting, drilling-down data in the reports without writing one formula or macro.
6) Linking data sources outside excel and be able to make pivot reports out of such data
Apr 29 2014 06:48 PM
SOME USES OF PIVOT TABLES:
1) Summarizing data like finding the average sales for each region for each product from a product sales data table.
2) Listing unique values in any column of a table.
3) Creating a pivot report with sub-totals and custom formats.
4) Making a dynamic pivot chart.
5) Filtering, sorting, drilling-down data in the reports without writing one formula or macro.
6) Linking data sources outside excel and be able to make pivot reports out of such data