I was given a task to create a local member TOTALS for a report with dynamic number of rows. Therefore, I can't just sum all those cells with an excel formula. Furthermore, even if I could, some data would be doubled because there are parent members.
Here's how my report should look(with row TOTALS under the report which shows sum of red circles without doubling the data):
The question is, are there any EPM functions that would allow me to sum data? And I don't want to use EPMRetrieveData in that case, because it's like double query to retrieve the same data.