.You insert items from the source tree as rows and columns in a crosstab to create sets for analysis. A set is a collection of like data. For example, you can have a set of data named years that includes quarters as details.
An analysis must have at least one set of items and at least one measure.
The default measure specifies the measure to use for a crosstab or chart if the measure is not set by one of the existing axes. For example, you create a crosstab with Products in the rows and Quantity Sold in the columns. You add Revenue to the Measure drop zone to make it the default measure, but the values in the rows do not change because they refer to the measure Quantity Sold in the column axis. However, if you replace the measure Quantity Sold with the non-measure Order Method, the values now refer to Revenue as the default measure.
Tip: To quickly change the default measure, right-click the cell in the upper left corner of the crosstab, click Change Default Measure, and choose a measure.
From the Settings menu, you can click Get Data Later to quickly create crosstab views that use complex filters and sets without executing a full query to the data source.
When working with Get Data Later applied, you cannot switch to a chart without first retrieving data. The Chart and Crosstab and Chart options from the View menu are unavailable.
Notes
When using a Cognos PowerCube as a data source, mixed currency values use the asterisk character (*) as the unit of measure. Mixed currency values occur when you calculate values with different currencies.
When you insert items from a relational data source containing sparse data, you may see data in the analysis appear and disappear unexpectedly. For example, a crosstab may contain 10 members along the rows and 10 members along the columns. When you add a member from another dimension to the context area, some members may disappear along the row or column because they are not in scope for that particular context. For more information, see the Framework Manager User Guide.
This can also occur when using SAP BW data sources.
In addition to items from the source tree, you can insert the following into the crosstab:
items retrieved in a search
levels from the Information pane
calculations
If you are interested in only the summarized results,
you can insert items without details .
You can also simultaneously insert all the items of a level ,
insert adjacent sets, or insert items from different levels of
the same dimension .
Other techniques for inserting items are nesting
items and
replacing items .
For information about different crosstab layouts that you can use, see Crosstab Layouts.
You cannot drag folders from the source tree.
If the crosstab contains fixed width columns, labels that exceed the fixed width are truncated and ellipses are shown. You can pause the pointer over the truncated cells to see a tool tip that shows the full information.
In the source tree, click the item that you want to insert.
Drag the item to the desired location in the crosstab.
A flashing black bar indicates where you can drop the item.
A detail-based set appears in the crosstab.
Tips
You can resize the columns in an open analysis
by dragging on the resize icon 
. However,
the new width cannot be saved. The columns return to the original
width after you close the analysis.
You can insert items as a selection-based set by pressing Shift+click or Ctrl+click to select multiple items in a dimension and then dragging them to the crosstab.
