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

Chapter 12. Working with PivotTable and ... > Slicing and Dicing Data with PivotTa...

Slicing and Dicing Data with PivotTables

PivotTables closely resemble Access crosstab query datasheets, which are one of the main topics of Chapter 11, “Creating Multitable and Crosstab Queries.” Both PivotTables and crosstab queries employ aggregate functions—sum, average, count, standard deviation, variance, and the likesummarize data, but PivotTables can handle the entire aggregation process. This enables PivotTables to selectively display the detail data behind subtotals and grand totals.

Crosstab queries are limited to creating row-by-row subtotals, with optional row (but not column) totals. PivotTables not only provide subtotals but also supply grand totals for rows and columns, plus crossfoot totals. Crossfooting is an accounting term for testing the accuracy of a set of numerical values by comparing grand totals calculated by row and by column. One of the primary advantages of PivotTables over crosstab datasheets is that the user, not the database developer who designed the query, can control data presentation.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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