I am using CR XI R2 and trying to create a cross-tab with two columns. This is what I want:
N Qtr 4 '06 N Qtr 1 '07 N Qtr 2 '07
Yes 108 87.1% 81 86.2% 85 88.5%
No 16 12.9% 13 13.8% 11 11.5%

This is what I am getting at the moment:

N
Qtr 4 '06 Qtr 1 '07 Qtr 2 '07
Yes 108 81 85
87.1% 86.2% 88.5%
No 16 13 11
12.9% 13.8% 11.5%

When I add more than one column it pushes the first column (N) up across the complete top. It then adds a Total column beside my (Qtr) column. In the above example I have suppressed the added Total Header and data.

Here is the setup of my Cross Tab Expert:

Columns - spReport.N
spReport.Qtr_Time

Rows - spReport.Answer

Summ. Fields - spReport.N
spReport.PercentN

Any help would be greatly appreciated!!

Ron