Welcome to the new CogKnowHow.com!

If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

Ratio on crosstab


i got a cross tab where i try tu create some ratio
1st measure is time wich is Type and team dependant
2nd measure is Opening time wich is only team dependant

[tr][td]Type1 [/td][td]time[/td][td]10[/td][td]15[/td][td]25[/td][td]50%[/td][/tr]
[tr][td]Type2 [/td][td]time[/td][td]5[/td][td]25[/td][td]30[/td][td]60%[/td][/tr]

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 ?