Open topic with navigation

Understanding the Summary Drilldown Report

The Summary report includes the Drilldown option for displaying data in an interactive pivot table format (Summary Drilldown). 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. 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.

• Double-click a total or sub-total to view or print details in a drilldown table.

  

  Summary Drilldown