Post reply

Matrix Report, Sum data at two Names Groups

  • March 25, 2012 at 7:58 am

    #253092

    Hello,

    I have a matrix report that has the toggle set both across the columns and rows.

    _________________Academic Year______

    _________________Age Group__________

    Directorate, Dept |

    I want to sum the values for use in a formula that works out a contribution rate. The problem is I need to be able to do

    Numbers at Dept Level / Numbers at Directorate level for that age group/academic year.

    So if we have

    ___________________|AG_|Total__

    Directorate A | Dept A | 20 | 50 |

    ---------------| Dept B | 30 | 50 |

    ___________________|AG_|Total__|

    Directorate B | Dept A | 70 | 170 |

    ----------------| Dept B| 100 | 170 |

    The final column total is the correct value I would like.

    But how can I achieve this please?

    Normally I would use

    =SUM(Fields!Start.Value,"AgeGroup")

    However where "AgeGRoup" is I would need both Directorate group and Age group so I can total on these.

    Any ideas please?

    Many thanks

  • March 26, 2012 at 9:17 am

    #1464344

    I would create a matrix in SSRS with column for Age Group. The data/detail row will be the counts. Then add two row groups - one parent for Department, then another parent group for Directorate. Then you can add a Total at the top or bottom with Group Properties> Right Click on the Group in the Group "box" at the bottom of the GUI in SSRS>Properties> Add Total> "Before" or "After."

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply