- Home
- Anonymous
- Sign in
- Create
- Ask a question
- Spaces
- Site Issues (NOT FOR DATABASE QUESTIONS)
- Explore
- Topics
- Questions
- Users
- Badges

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.

ssrscalculationsmatrix
Comment

How about changing the query so the results are all in the same dataset?

**15** People are following this question.

Copyright 2022 Redgate Software.
Privacy Policy