Post reply

SSRS 2008: How to build a subtotal of two columns depending on their contexts

  • October 12, 2010 at 3:35 am

    #225011

    Hey guys,

    I've got following issue. I have a matrix like this

    Months

    Sales January February March April May ... January + February February + April

    10 20 15 5 30 ? ?

    I have a row group "Sales" and a column group "Months". Now i need to build different subtotals oh the column group, for example January+February. Which would be 30 in this case.

    Any ideas how ideas how i can build these totals???

    Thank you

    Alina

  • October 12, 2010 at 10:15 pm

    #1235974

    Hi,

    SSRS does provide such dynamic columns associating but if time is constraint I would suggest using a Pivot Transformation in your underlying SQL query and populate it on SSRS reports, table preferably:-)

    Raunak J

  • October 13, 2010 at 3:07 am

    #1236041

    Hi,

    I don't really understand your answer. Could you make an example.

    And why would you use a table instead of matrix?

    Thank you!

  • October 13, 2010 at 3:13 am

    #1236043

    Hi Alina,

    Please click here

    Raunak J

  • October 14, 2010 at 2:48 am

    #1236681

    Thank you Raunak! That's a really great idea to pivot the data with sql.

    For two days i've been looking for a solution, thinking reporting services must have such a feature. But it works just perfectly with sql and table. So thank's a lot!

    Alina

  • October 14, 2010 at 3:09 am

    #1236689

    Happy to help.:-)

    Raunak J

Viewing 6 posts - 1 through 5 (of 5 total)

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