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

Author Topic: % of total calculation not working when dimension is nested (AS)  (Read 2216 times)

tyody

  • Guest
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!