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



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

Main Menu

Percent of Base (coming from Powerplay)

Started by norman, 02 Jun 2011 12:32:51 PM

Previous topic - Next topic


Is there any way to have a Percent of Base in Analysis Studio?
We have used it the Powerplay and it is one of the users' favorite feature.
It is similar to Percent of Total but instead of the Total being the base, a different row is used as base.

Our typical use is to determine the % of Sales for each member in the "P&L" dimension displayed:
                             $   % of Base
Sales                 500   100%
Materials           150     30%
Labor                  75     15%
Overhead            20      4%
Profit                255      51%
Any hints are welcome!