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)
“Comes the time when it’s later
and onto your table the headwaiter
puts the bill,”
—Robert Creeley (b. 1926)
“On pragmatistic principles, if the hypothesis of God works satisfactorily in the widest sense of the word, it is true.”
—William James (1842–1910)