Trying to sum the rows of data for Columns Count and Amount:
Design View:
Results View:
Have used the following expressions:
- =IIF(InScope("DataSet1"),Sum(Fields!Count.Value, "DataSet1"), " ") - Get #error
- =Sum(Fields!Count.Value) - Get #error
- Using the Row Groups/Add total/ After, which adds [First(#Count)] returns results from January of 11
Does someone have an expression that would return the sum of the data for columns?
Regards,
jer