COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Analysis Studio => Topic started by: tyody on 03 Apr 2007 03:33:19 PM

Title: % of total calculation not working when dimension is nested (AS)
Post by: tyody on 03 Apr 2007 03:33:19 PM
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!