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)
“When I think of our lands I think of the house
And the table that holds a platter of pears,
Vermilion smeared over green, arranged for show.”
—Wallace Stevens (1879–1955)
“I shall not bring an automobile with me. These inventions infest France almost as much as Bloomer cycling costumes, but they make a horrid racket, and are particularly objectionable. So are the Bloomers. Nothing more abominable has ever been invented. Perhaps the automobile tricycles may succeed better, but I abjure all these works of the devil.”
—Henry Brooks Adams (1838–1918)