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

Ratio on crosstab

Started by Sebhash, 07 May 2013 05:28:45 AM

Previous topic - Next topic

Sebhash

Hi,

i got a cross tab where i'm trying to create some ratio (column Percent)
1st measure is time wich is Type and team dependant
2nd measure is Opening time wich is only team dependant


Team1Team2SumPercent
Type1 time10152550%
Type2 time5253060%
Openingtime203050

My percent should be the total(time)/total(Openingtime for report) -> 25/50 for the first line = 50%

If i use the measure Openingtime in my query item Percent, the cell is empty.

how can i do that ?

Thx