Advanced Matrix - Total Sum from Max Datacell
Hello,
I have a Advanced Matix with a Datacell Max(Result) of every day.
Now I want a Total Sum of every Max(Result). GrandRowTotal and other Test's doesn't work :-(
Can you help me?
Greetings
Konrad
This discussion has been closed.
Comments
try this...
Thank you :-)
I found a solution over a new connection and SelectCommand with group and max.
Greetings
Konrad
Hello!
In matrices (including Advanced Matrix and the classic MatrixObject), the GrandTotal cell is designed to apply an aggregate to the source values (i.e. Max(all cells)), rather than the sum of the maximum values across columns/days.
To obtain the Sum of Daily Max (the sum of the maximum values by day):
First, aggregate MAX(Val) by each day in the SelectCommand or add a separate summary table/column.
Create a GroupHeader by day, add a Total of type Max (reset to GroupFooter) and, in GroupFooter_BeforePrint, accumulate its value into the variable sumOfDailyMax += Convert.ToDecimal(Report.GetTotalValue(‘DailyMax’)), displaying [sumOfDailyMax] in ReportSummary.