SSRS 2005 Matrix Total column

  • yheon_17 66014

    SSC Rookie

    Points: 46

    Hi,

    I need help on using SSRS 2005 Matrix. I need to add the last 3 columns. Kindly refer on the diagram. Thank you very much.

    Country Year

    2001 2002 2003 2004 Total for last 3 Years

    USA 12 5 3 4 12

    CHINA 12 2 2 6 10

    BRAZIL 12 1 7 8 16

    SPAIN 12 3 4 4 11

    Thanks,

    Perry

  • kamal.agarwala

    Grasshopper

    Points: 18

    Hi,

    As per my knowledge you can do it by two ways

    1. from databse script where you write the storeprocedure.

    2. you have to write the code for this in ssrs in which you will explictly add 3 columns only.

  • yheon_17 66014

    SSC Rookie

    Points: 46

    Hi Grasshopper,

    Thanks for your reply. Is there a way to this in SSRS 2005 with out doing it in Strored Proc?

    Thanks,

    Perry

  • Edward Boyle-478467

    Ten Centuries

    Points: 1113

    Try using the Inscope Function

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

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