Specify the Default Measure

You can specify the default measure for crosstabs and certain chart types. Specify the default measure to be used when the measures cannot be determined by what is on the edges. For example, you create a crosstab with Order method as rows and Product line as columns. You add Quantity and Revenue as nested rows, making Order method their parent. You then add Country or Region under Order method. Since there is no measure specified for Country or Region, you specify the default measure so that data is returned for each country or region.
Note: In crosstabs, IBM® Cognos® Report Studio automatically sets the default measure when you insert a measure into the crosstab cells.

Procedure

  1. To specify the default measure for a crosstab, do the following:
    • Click any part of the crosstab, and then click the select ancestor button select ancestor icon in the title bar of the Properties pane.
    • Click Crosstab.
      Tip: You can also click the container selector (three orange dots) of the crosstab to select it.
    • Set the Default Measure property to the default measure.
  2. To specify the default measure for a chart, drag the measure to the Default measure box in the chart.
Parent topic: Crosstabs