Hi, thanks for the response, it's not quite what I had in mind as I was hoping to use SSRS functions to present the data on the face of the report

I have a single data-set that returns a list of all the widgets over two years. The idea is to display a summary of the data in a matrix below which would then be a table with the detailed data

On the matrix, the cumulative, or, running totals should display from left-to-right along each row where each row represents a type of widget and the column groups are month within quarter within year. The running or cumulative totals are the year-to-date values for each year

If I use the SSRS RunningValue function referencing the row group the result is a simple accumulation along each row that ignores the column groups. Consequently the result for column d is the sum a+b+c+d, which is fine but if column d is in the year after a, b & c I want the column value to be simply the value of d (if c and d are in the next year to a and b the value for column d would be the sum of c plus d)

I had thought there would be a way of referencing the Year column group in the value expression but cannot find any information on this

Thanks