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:
“Herein is the explanation of the analogies, which exist in all the arts. They are the re-appearance of one mind, working in many materials to many temporary ends. Raphael paints wisdom, Handel sings it, Phidias carves it, Shakspeare writes it, Wren builds it, Columbus sails it, Luther preaches it, Washington arms it, Watt mechanizes it. Painting was called “silent poetry,” and poetry “speaking painting.” The laws of each art are convertible into the laws of every other.”
—Ralph Waldo Emerson (1803–1882)
“How strange a scene is this in which we are such shifting figures, pictures, shadows. The mystery of our existence—I have no faith in any attempted explanation of it. It is all a dark, unfathomed profound.”
—Rutherford Birchard Hayes (1822–1893)
“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)
“... So damn your food and damn your wines,
Your twisted loaves and twisting vines,
Your table d’hôte, your à la carte,
. . . .
From now on you can keep the lot.
Take every single thing you’ve got,
Your land, your wealth, your men, your dames,
Your dream of independent power,
And dear old Konrad Adenauer,
And stick them up your Eiffel Tower.”
—Anthony Jay (b. 1930)