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!