A pivot table is a table that summarizes data from another table, and is made by applying an operation such as sorting, averaging, or summing to data in the first table, typically including grouping of the data. A trivial example is a column of numbers as the first table, and the column average as a pivot table with only one row and column. A slightly less trivial example is a table with columns sex and height, each row giving the sex and height of a person, and a pivot table made from it with the same two columns but only two rows, with 'male' and 'female' in the sex column and the average height of each sex in the height column. A third more complex and more typical example adds another dimension to the pivot table: a data table has columns month, salesperson, product and sales, each row giving the total sales of some product by some salesperson in a certain month, and a pivot table made from it has a first column salesperson of salespeople names and the remaining column names are product names and contain the total sales by that salesperson of that product over all months. Pivot tables are used in and are found in data visualization programs such as or software. Such programs can automatically sort, count, total or average the data stored in one table or spreadsheet, displaying the results in a second table — the pivot table — showing the summarized data.
![Tablas Dinamicas Excel 2013 Tablas Dinamicas Excel 2013](https://blogs.itpro.es/exceleinfo/files/2017/07/SNAGHTML1c967033.png)