Calculate total by summing max numbers

0
votes

I have a Matrix report that has two row groups and two column groups. There is column which has the calculation Max(Fields!AdjustedManning.Value) on the Row Group level as a subtotal. I want to add a total at the bottom which is outside of the row group to sum the subtotal numbers up. What expression can I use to do this? Effectively I'm looking to sum the max numbers

In the image the yellow box for design is where I need to put the expression and a preview of what I would expect it to calculate.

Design and Preview

1
reporting-services
what happens if you sum the report item? Say the text box name for the cell max(adjusted..) is called max_adjusted_text.. simply use the expression =Sum(Reportitems!max_adjusted_text.value) in the yellow total cell. does it give you the desired result? – Harry
I get the following error The Value expression for the textrun 'Textbox174.Paragraphs[0].TextRuns[0]' uses an aggregate function on a report item. Aggregate functions can be used only on report items contained in page headers and footers. – Benjamin Humphrey

1 Answers

0
votes

You didn't show the rowgroup names so I'm guessing you have a rowgroup grouped by [WoLine] called Woline. Assuming this is correct then you should be able to use something like...

=SUM(MAX(Fields!AdjustedManning.Value, "WoLine"))

"WoLine" is the name of the rowgroup, you must include the quotes and it is case sensitive so adjust to suit your actual report.

What this does is get the MAX value within the "WoLine" rowgroup scope and then sum the results.