I'm having problems getting a report to give me totals of calculated data at the lowest level.
What I'm trying to do is build derived categories based on particular percentages at the lowest level.
I can do this, but a summarised report is required with totals of the lowest level.
I want these totals only (not each record) at the summary level. I'm sure it's achievable but I must be doing something wrong. This should be straight forward.
Hi,
Are the derived members assembled into a set? If so, you could use an expression such as
aggregate(currentMeasure within set [your set of members])
If your members are not already in a set, then you could use a set() function in the expression.
Regards,
MF.