Microsoft Office Tutorials and References
In Depth Information
Another Pivot Table Example
Figure 18-41: After expanding the pivot table, formulas that use the GETPIVOTDATA function continue to
display the correct result.
Another Pivot Table Example
The pivot table example in this section demonstrates some useful ways to work with pivot tables.
Figure 18-42 shows a table with 3,144 data rows, one for each county in the United States. The
fields are
h County: The name of the county.
h State Name: The state of the county.
h Region: The region (Roman number ranging from I to XII).
h Census 2000: The population of the county, according to the 2000 Census.
h Census 1990: The population of the county, according to the 1990 Census.
h Land Area: The area, in square miles (excluding water-covered area).
h Water Area: The area, in square miles, covered by water.
 
Search JabSto ::




Custom Search