SQL Server Performance

Reporting Services Matrix Question

Discussion in 'SQL Server 2005 Reporting Services' started by consolidata, Oct 10, 2007.

  1. consolidata New Member

    Hi, I would like to know if it is possible to refer to a grouping within a matrix from another matrix.
    eg. TopMatrix has grouping Industry (Education £10, Pubs £20)
    BottomMatrix has the same grouping
    I am trying to do the following calculation in BottomMatrix(simplified)
    =Sum(Fields!GroupValue.Value) / Sum(Fields!GroupValue.Value, "TopMatrix")
    The problem is that it divides by the total of all the groups (in this case £30) instead of each group. So I get Education / £30 and Pubs / £30 instead of Education / £10 and Pubs / £20. I dont seem to be able to scope the grouping in TopMatrix, only TopMatrix itself. Would be nice to be able to scope something like TopMatrix.Industry
    Any ideas?
  2. satya Moderator

Share This Page