Good Day All
I have an SSRS report with a tablix where I need to return the closing balance based on the max value returned. I have attached a file with details of what i am looking for. Essentially my tablix has a SUM function as a total and for this one row, I need to SUM and keep the Scope in line with the child group immediately below this one.
Updating the Sum with scope as the child group fails saying the scope is invalid
"The Value expression for the text box ‘ELIS_LY4’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset"
Please see attached and let me know if I need to clarify anything..Thank you for your help