Post reply

Percentage with total in matrix

  • May 16, 2010 at 1:08 pm

    #221582

    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

  • May 17, 2010 at 7:55 am

    #1168269

    [/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

  • May 18, 2010 at 7:34 am

    #1168810

    Thank you.

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

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