Pivot Table Reports 101
Let's suppose you've compiled a large list of data-for example, sales figures for every product your company makes. A list is series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command. For this you can create a PivotTable report-an interactive table that automatically extracts, organizes, and summarizes your data. You can use this report to analyze the data, make comparisons, detect patterns and relationships, and discover trends. This paper explains how to prepare the pivot table reports.