Microsoft Office Tutorials and References
In Depth Information
Tip 77: Identifying Data Appropriate for a Pivot Table
Figure 77-4 shows the same data, but normalized. This range contains 78 rows of data — one for
each of the six monthly sales values for the 13 states. Notice that each row contains category
information for the sales value. This table is an ideal candidate for a pivot table and contains all
information necessary to summarize the information by region or quarter.
Figure 77-5 shows a pivot table created from the normalized data. As you can see, it’s virtually
identical to the non-normalized data shown in Figure 77-3. Working with normalized data provides
ultimate flexibility in designing reports.
Figure 77-4: This range contains normalized data and is appropriate for a pivot table.