When you insert into the cross tab a dimension that contains multiple levels (for example, year, quarter, month), by default, the cross tab displays only the top level. You can, at any time, select additional levels to display. You can even skip levels. For example, in a year-quarter-month hierarchy, you can display the year and the month, and skip the quarter.
How to display or hide levels
1 Click the button next to the data element, as shown in Figure 23‑38.
Figure 23‑38 Displaying a menu for a selected element in the cross tab
2 Choose Show or Hide Group Levels.
3 In Show or Hide Group Levels, select the levels to display. Figure 23‑39 shows an example of selecting all levels.
Figure 23‑39 Show or Hide Group Levels
In the example, the time dimension has only three levels. If you want to display additional levels, such as week-of-month or day-of‑month, edit the definition of the time dimension in the cube builder.
4 Choose OK. BIRT creates a data element for each selected level, as shown in Figure 23‑40.
Figure 23‑40 Cross tab displays a data element each for the year, quarter, and month levels
