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

percentage of moving base because of drill down

Started by tibo, 14 Apr 2011 05:42:29 AM

Previous topic - Next topic

tibo

Hi,


I have a crosstab with 2 different dimensions in the rows and another dimension in the coloms.

As measures I have absolute numbers and a percentage based on the total of top level of the dimensions in the rows.

I want an extra percentage which is based on the total of the second level after the 1st drill down on a dimension in the rows. And changes again when another drill down is performed in which case the percentage is calculated on the total of the third level.   

Can someone help me with this? Thanks

Tibo