If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Summarising Low level calculations

Started by ferrit, 15 Sep 2010 07:44:38 PM

Previous topic - Next topic

ferrit

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. 

MFGF

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.
Meep!