How to drill up through a category series to view summary information
To drill up to a higher level in the data hierarchy, from the context menu, as shown in
Figure 8‑34, choose Drill up to 'Year' or Drill up to 'Quarter'.
Figure 8‑34 Drill-up menu
The chart in the report displays the data for the selected category.
In the following example, the category axis displays the product line, and the value axis displays sales. The data in the value series is grouped by year. You can drill down to view sales by product line for each year, or up to a higher level to view summary information across years.