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
| | Team1 | Team2 | Sum | Percent |
| Type1 | time | 10 | 15 | 25 | 50% |
| Type2 | time | 5 | 25 | 30 | 60% |
| Openingtime | | 20 | 30 | 50 | |
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