How A Pivot Table Works
Using the example above, software will find all distinct records for Region. In this case, they are: North, South, East, West. Furthermore, it will find all distinct records for Ship Date. Based on the aggregation type, sum, it will summarize the fact and display them in a multidimensional chart. In the example above, the first datum is 66. This number was obtained by finding all records where both Region was East and Ship Date was 1/31/2005, and adding the Units of that collection of records (i.e. cells E2 to E7) together to get a final result.
Read more about this topic: Pivot Table
Famous quotes containing the words pivot, table and/or works:
“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)
““A sigh for every so many breath,
And for every so many sigh a death.
That’s what I always tell my wife
Is the multiplication table of life.””
—Robert Frost (1874–1963)
“We ourselves are Jews by birth and not Gentile sinners; yet we know that a person is justified not by the works of the law but through faith in Jesus Christ. And we have come to believe in Christ Jesus, so that we might be justified by faith in Christ, and not by doing the works of the law, because no one will be justified by the works of the law.”
—Bible: New Testament, Galatians 2:15-16.