Percentage row in a crosstab

[Matt27]

I have a cross tab. This has the period in the row and a percentage formula as the column. This in itself works absolutely fine. However, when I add a second percentage field to the cross tab and put it in as a second row, rather than giving me one figure per period, it splits it into 2 or 3 figures. Does anyone know why and how to get around this?

 

[Matt27]

I can now see why it's giving me 2 or 3 rows. In the formula for the new row I am restricting it to 5 categories of the field used for the columns. It's giving me one row total for these five and then a seperate row for each of the other categories contained in this column field. So how do I stop it doing this and get it just to give me one row total?

 

[Matt27]

I have now created a shared variable to produce the result, but now the only problem is that when I add this variable to the cross tab it only gives me the figure for the first load period (row 1 in my cross tab). Any ideas??

 

[Matt27]

I've now resolved this myself!!