[RESOLVED] Cross-tab question

[conwa02976]

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

[Chrissy]

I'm not sure what "N" is, but if each instance of "N" pertains to the Qtr_Time, why not make "N" a row? Maybe you could explain what "N" holds.

[conwa02976]

Sorry,

Yes and No are answers to a survey question. N is the number of responses for each answer to that question and PercentN is the percentage of each answer to that question.

So, for Qtr 4 '06, 108 responses were Yes and 16 responses were No. That gives a respective percentage of 87.1% for Yes and 12.9% for No.

The reason for the cross tab is to show a trend of responses across time periods.

Thanks for your help!!