What is the effect of changing the Default measure property of a Crosstab in a report if a measure is already set by one of the existing edges?

Question

Options

• Athe Crosstab values remain the same and the Crosstab comer displays the Default measure's name
• Bthe Default measure replaces the existing measure in the Crosstab edges
• Cthe Default measure is displayed in the Crosstab intersections
• Dan error is produced

• A
  89% (51)
• B
  5% (3)
• C
  2% (1)
• D
  4% (2)

Explanation

Option A is correct because in a Crosstab, edge-level measures take precedence over the Default measure - so existing values are unaffected. The Default measure's role is reduced to labeling the corner cell of the Crosstab, which is the intersection of the row and column header areas.

Option B is wrong because the Default measure does not override or replace measures already assigned to edges; the edge measure always wins. Option C is wrong because the intersections display the edge-defined measure's values, not the Default measure's values - the Default measure only influences behavior when no edge measure is present. Option D is wrong because this is a perfectly valid configuration that produces no errors.

Memory tip: Think of the Default measure as a fallback label - when an edge "claims" the measure, the Default measure gets pushed to the corner as a nameplate, doing no real calculation work.

No community discussion yet for this question.