DE
ENVariances become subtle when measures and dimensional members are nested in a crosstab.
Practical approach
Define explicitly which actual and comparison values should be used at each intersection and perform the calculation at the correct aggregation level.
Validation and limitations
Test grand totals separately from detail rows; percentage variances should generally be calculated from aggregated base values.
AI-assisted translation and adaptation.
