SSRS 2005 Matrix Total column

  • 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.

    CountryYear

    2001200220032004Total for last 3 Years

    USA1253412

    CHINA1222610

    BRAZIL1217816

    SPAIN1234411

    Thanks,

    Perry

  • 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.

  • Hi Grasshopper,

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

    Thanks,

    Perry

  • Try using the Inscope Function

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

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