Post reply

SSRS Dynamic Column Grand Total to calculate the variance data

  • November 9, 2015 at 6:42 am

    #312990

    Hi All,

    I have a matrix report which contains yearly data grouped by category and i have generated grand total value for each year for each category. Now i need to use these dynamic grand total values in another calculation. For ex: for the year 2014 for the category "A" the grand total is 1000 and the grand total for the same category in 2015 is 1020. Now i need to use these two values in another calculation. Its like current year and previous year total value for the same category. The category and year are dynamic. There are n number of categories listed so cannot hard code the group details.

    Can anyone suggest a method to do the same.

    Regards,

    Sandeep

  • November 13, 2015 at 4:26 am

    #1839573

    Got the correct answer from stackoverflow.

    http://stackoverflow.com/questions/33670332/ssrs-dynamic-columns-grand-total-required-to-be-copied-and-use-the-same-in-anoth

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

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