Başlıkları göster

pivot table is a table that summarizes data in 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, salesman, product, and sales, each row giving the total sales of some product by some salesman in a certain month, and a pivot table made from it has a first column salesman of salesmen names and the remaining column names are product names and contain the total sales by that salesman of that product over all months.

11.01.2018 15:13