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