Simply put, pivot tables let you look at the same data in different ways and from different angles, to make it easier to perform in-depth analysis and to spot important trends. When you’re ...

For example, you could query to find and extract all records that contained sales greater $1000 but less than $5000—but only on flat files (only one database matrix). Pivot Tables were developed ...