Matrix Row Totals

Trying to sum the rows of data for Columns Count and Amount:

Design View:

Results View:

Have used the following expressions:

  1. =IIF(InScope("DataSet1"),Sum(Fields!Count.Value, "DataSet1"), " ") - Get #error
  2. =Sum(Fields!Count.Value) - Get #error
  3. 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

July 11th, 2015 10:46pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics