COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ferrit on 15 Sep 2010 07:44:38 PM

Title: Summarising Low level calculations
Post by: ferrit on 15 Sep 2010 07:44:38 PM
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. 
Title: Re: Summarising Low level calculations
Post by: MFGF on 16 Sep 2010 05:02:22 AM
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.