views:

680

answers:

0

Hi,

I have a dataset that returns the following columns,

CategoryID, CategoryName, CategoryParentID, MonthIndex, Amount

I am adding this to a Matrix in SSRS 2008 and configuring for a recursive hierarchy which works fine. However, when I change the column from a

SUM(Fields!Amount.Value)

to a

SUM(Fields!Amount.Value, "GroupName", Recursive)

All of my month columns contain the same values - I am assuming because they all exist under the same scope?

Does anyone know how to perform a Recursive aggregate using a Matrix?

Thanks,