Hi, I've got a matrix with a nested Year and Month hierarchy for the rows (1st column Fisc Yr, next column Month), and then for the columns along the top I've got a number of channels for recruitment. I want to be able to view a percentage calculation cumulatively by year, but also by channel, so I want to see: ...where the runningvalue sum operates within the years down the page, but resets with each column. At the moment I've tried: =RunningValue(Fields!GrpTotal.Value, sum,"Date_Recruited_Fisc_Yr") Although this does create a running total which resets on the first row of each new year, it works the runningvalue calculation across the columns before dropping down to the next row, which isn't what I'm after. I've looked everywhere for advice on this as it feels like it should be such a simple thing, but I can't work it out. Can anyone help? Thanks

Hi There You can put expression like this to get the running total of your matrix group =RunningValue(sum(iif(Fields!StatusName.Value="Invoice",Fields!EndQOH.Value,0)), sum,"company") Where company is group which is equlivant to your year group and StatusName is the coulmn group field which is equilavent to your channels for recruitment I am putting some screenshot for your help Please let me know if you have any questions Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful --for check =RunningValue(sum(iif(Fields!StatusName.Value="Check",Fields!EndQOH.Value,0)), sum,"company") --for Invoice =RunningValue(sum(iif(Fields!StatusName.Value="Invoice",Fields!EndQOH.Value,0)), sum,"company") -- for void check =RunningValue(sum(iif(Fields!StatusName.Value="Void Check",Fields!EndQOH.Value,0)), sum,"company")

Hi Syed, Many thanks for your reply - I think we may be on the right track, but this isn't currently working for me. I think the problem that I have is that my columns (i.e. 'Direct Mail', 'Telemarketing', 'Door to Door' in the exampled) are all populated from one field called 'RecruitmentChannel' rather than pulled into the matrix as separate fields for each category, so the IIF statement part of your solution doesn't seem to work. Just to add a complication, there is a filter on which categories in the 'RecruitmentChannel' field are displayed, which is run off of a parameter. Is there another way around this? Thanks!

Hi There I know 'RecruitmentChannel' is your column group and here the limitation of SSRS 2008 that you would not be able to use column and row group together in scope statement for running value. If you have noticed that is why I have used IIF statement with StatusName which is my column group and off course it is equivalent to your 'RecruitmentChannel'. You could either do this way by putting iif condition or you can refer to the following post. http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/f279d2e6-560b-447d-a342-a970a51071bf Please let me know if you have any questions Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Hi There I know 'RecruitmentChannel' is your column group and here the limitation of SSRS 2008 that you would not be able to use column and row group together in scope statement for running value. If you have noticed that is why I have used IIF statement with StatusName which is my column group and off course it is equivalent to your 'RecruitmentChannel'. You could either do this way by putting iif condition or you can refer to the following post. http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/f279d2e6-560b-447d-a342-a970a51071bf Please let me know if you have any questions Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Thanks Syed, So it looks like, due to a limitation of SSRS 2008, that it's not possible to do what I'd like to without having separate tables or separate reports. Is that correct? I've tried the IIF condition, using one of my column headings as a test, but it just brings me back the same results for each column in the group. Thanks for your help though Syed.