How to add a dimension to cross-tab columns
Drag a dimension from the data pane, and drop it in Columns in the structure pane. Figure 3-3 shows dragging a Year dimension from the data pane and dropping it in Columns in the structure pane.
Figure 3-3  
Data Analyzer updates the cross tab, adding the Year dimension columns in each PRODUCTLINE column, as shown in Figure 3-4.
Figure 3-4  

Additional Links:

Copyright Actuate Corporation 2012