Matrix mulitplying columns of summed rows

[pludlow]

-Comparing vehicle production forecast at different points in time. Calculating their variance and then using that with $/vehicle to estimate a $ variance by month

-Var Apr19 to budget is a measure, $’s per vehicle is a column in its’ on query

-

Issue

-Adding subtotals to the matrix

-Variance by vehicle line like DK is correct

-Variance by Fiat Chrysler is no good. This line is summing up all the variances for Fiat Chrysler and multiplying it by the summed $’s/vehicle.

-This calculation does not match the actual sum of Var $’s

-budget, apr19, $’s vehicle related to each other by program code

[v-yulgu-msft]

Hi @pludlow ,

You may have a look at this thread:

Dealing with Measure Totals

Best regards,

Yuliana Gu