SSRS How do I divide column group totals of two matrices that use different datasets?
I have an SSRS Report that has two matrices with a different dataset in each matrix. I have a total column in each matrix. I want to perform a calculation on the values in the totals columns. Here is what I want to do: MatrixA.TotalColumn.Value divided by MatrixB.TotalColumn.Value So I want to see a column of values showing the calculation between the two. MatrixA uses a different dataset than MatrixB. Both MatrixA and MatrixB have the same number of rows and columns. There is a total column on the column group for each matrices. I want to see a column of values of the division of the total columns.