Explanation of A Pivot Table
For typical data entry and storage, data usually appear in flat tables, meaning that it consists of only columns and rows, as in the following example showing data on shirt types:
While tables such as these can contain a lot of data, it can be difficult to get summarized information from them. A pivot table can help quickly summarize the data and highlight the desired information. The usage of a pivot table is extremely broad and depends on the situation. The first question to ask is, "What am I looking for?" In the example here, let us ask, "How many Units did we sell in each Region for every Ship Date?":
A pivot table usually consists of row, column and data (or fact) fields. In this case, the column is Ship Date, the row is Region and the datum we would like to see is (sum of) Units. These fields allow several kinds of aggregations including: sum, average, standard deviation, count etc. In this case, the total number of units shipped is displayed here using a sum aggregation.
Read more about this topic: Pivot Table
Famous quotes containing the words explanation of, explanation, pivot and/or table:
“What causes adolescents to rebel is not the assertion of authority but the arbitrary use of power, with little explanation of the rules and no involvement in decision-making. . . . Involving the adolescent in decisions doesn’t mean that you are giving up your authority. It means acknowledging that the teenager is growing up and has the right to participate in decisions that affect his or her life.”
—Laurence Steinberg (20th century)
“The explanation of the propensity of the English people to portrait painting is to be found in their relish for a Fact. Let a man do the grandest things, fight the greatest battles, or be distinguished by the most brilliant personal heroism, yet the English people would prefer his portrait to a painting of the great deed. The likeness they can judge of; his existence is a Fact. But the truth of the picture of his deeds they cannot judge of, for they have no imagination.”
—Benjamin Haydon (1786–1846)
“The seagull’s wings shall dip and pivot him,
Shedding white rings of tumult, building high
Over the chained bay waters Liberty—
Then, with inviolate curve, forsake our eyes”
—Hart Crane (1899–1932)
“The newspaper is a Bible which we read every morning and every afternoon, standing and sitting, riding and walking. It is a Bible which every man carries in his pocket, which lies on every table and counter, and which the mail, and thousands of missionaries, are continually dispersing. It is, in short, the only book which America has printed, and which America reads. So wide is its influence.”
—Henry David Thoreau (1817–1862)