The Summary report includes the Drilldown option for displaying data in an interactive pivot table format (Figure 15-20). This feature allows you to display different representations of the same summary data. You can add, remove, and rearrange filters to display a subset of summary data for easier analysis of large amounts of data. Double-clicking a field opens a window with detailed drilldown information for the selected summation type (Figure 15-18). Percentage drill downs are currently unavailable. The following list describes operations you can perform in a pivot table:
|
•
|
Arranging Column Fields in the Grid: The arrangement of filter buttons correspond to the arrangement of column fields in the grid. Dragging a filter button to a different position within the group of buttons subsequently rearranges column fields in the grid. Hovering the mouse over a filter button displays a tooltip with the filter name.
|
|
•
|
Removing Column Fields in the Grid: Dragging a filter button to the area of the pivot table labeled “Drop Column Fields Here” removes the selected column from the grid.
|
|
•
|
Removing Filters from Calculations: Dragging a filter button to the area of the pivot table labeled “Drop Filter Fields Here” removes the selected filter from calculations.
|
Figure 15-20. Summary Drilldown