The Default 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.

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.