Report Studio

Specifying the Default Measure

 

Specify the default measure to be used when a measure is not specified on a row or column edge. 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 under Order method. Since there is no measure specified for Country, you specify the default measure so that data is returned for each country.

Report Studio automatically sets the default measure when you insert a measure into the crosstab cells.

To Specify the Default Measure:

  1. Click any part of the crosstab, and then click the select ancestor button in the title bar of the Properties pane.
  2. Click Crosstab.
  3. Set the Default Measure property to the default measure.

 

Related Topics: