• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Pivot Tables and Pivot Charts

Chapter 14. Pivot Tables and Pivot Charts

In Chapter 9, “Queries, Part II,” you learned about crosstab queries; in this chapter, you learn about pivot tables. Both summarize data in two-dimensional matrixes. But pivot tables are much more powerful than crosstab queries: They add extra levels of detail for more in-depth analysis. They are extremely flexible, so you can “slice and dice” your data in many ways. They make it easy to find all kinds of totals, such as sums, counts, and averages, for many sets and subsets of data.

And pivot tables are fun. Yes, they do entail a learning curve. There's a lot going on in a pivot table, and you can set many properties that affect both substance and appearance. But when you know how pivot tables work, you'll find yourself pivoting like crazy. Pivot tables are useful for managers who want to view and analyze data from many standpoints. You can quickly move from finding the average monthly revenue of the Wilmington office for the third quarter to finding the total number of orders for the Dayton branch last year. Extended analysis can be a substitute for action, but more frequently, the powerful analytical tools that pivot tables offer will help you make better decisions.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint