Microsoft ® Office 2007 Business Intelligence

2.1. What Is a PivotTable?

In the working world of desktop business intelligence tools, Excel is used by millions of people for spreadsheets of text and numbers, row and column calculations, and meetings and sales presentations. But what if those rows and columns could provide an interactive experience that would allow us to easily click and arrange the data cells on the computer screen for our own analysis or during meetings with other people—with automatic formatting and totaling on the fly?

Technology Positioning Statement PivotTables are probably the most improved area of the Excel product, particularly from a BI perspective. Most notable is the replacement of the old drag-and-drop interface with a new field well dialog box that enables ...