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

% of total calculation not working when dimension is nested (AS)

Started by tyody, 03 Apr 2007 03:33:19 PM

Previous topic - Next topic

tyody

Hi everyone -

I have a report in Analysis Studio that has Organization as columns and revenue as a measure.  I've inserted a calculation that shows the revenue for each organization as a % of the total.  This works fine.  The problem is when I expand the Organziation level (expand - not down a level) - I lose my % of total values.  The calculation no longer works at the second level of the hierarchy. Anyone experience this or know why its happening?

Thanks for the help!