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


#1

Hi,

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

[table]
[tr][td][/td][td][/td][td]Team1[/td][td]Team2[/td][td]Sum[/td][td]Percent[/td][/tr]
[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]
[tr][td]Openingtime[/td][td][/td][td]20[/td][td]30[/td][td]50[/td][td][/td][/tr]
[/table]

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