Percentage with total in matrix

  • Hi,

    I have a matrix

    total jan feb mar

    typeX 3 1 2 0

    typeY 4 2 1 1

    I want % as follows

    total jan feb mar

    7 3 3 1

    tupeX% 42.1% 33.1% 66.1% 0%

    type Y% 57.1% 66.1% 33.1% 100%

    typeX 3 1 2 0

    typeY 4 2 1 1

    Can you help me?

    Thanks,

    BMR

  • [/url]SSRS 2005 matrixes do not support any other aggregation than sum in subtotal/total row. You can either complete the calculations in the data source, or you can split the data portion of the matrix into multiple parts by adding more than one text box within a single field. Mr. Martin Cremer has some idea for this situation in his posting: Reporting Services: Adding extra columns / rows to a matrix

    By Martin Cremer, 2008/07/24

  • Thank you.

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

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