« Return to Thread: Setting pivot table dimensions

Setting pivot table dimensions

by Melissa Ives :: Rate this Message:

Hello all,

I am looking for a way to set crosstab and means tables to default to a different setting in crosstabs from this:

Title
			Studyid Study ID-text (Not to be confused with XStudy)			Total
			1	2	3	Total
VARB	A	Count	468	132	26	626
		% within VARB	74.8%	21.1%	4.2%	100.0%
		% within Studyid	47.7%	52.8%	47.3%	48.7%
	B	Count	513	118	29	660
		% within VARB	77.7%	17.9%	4.4%	100.0%
		% within Studyid	52.3%	47.2%	52.7%	51.3%
Total		Count	981	250	55	1286
		% within VARB	76.3%	19.4%	4.3%	100.0%
		% within Studyid	100.0%	100.0%	100.0%	100.0%

to this (i.e. move the statistics dimension in the row from 1 to 0 (from second to first).

Title
			Studyid Study ID-text (Not to be confused with XStudy)			Total
			1	2	3	Total
Count	VARB	A	468	132	26	626
	VARB	B	513	118	29	660
	Total		981	250	55	1286
% within VARB	VARB	A	74.8%	21.1%	4.2%	100.0%
	VARB	B	77.7%	17.9%	4.4%	100.0%
	Total		76.3%	19.4%	4.3%	100.0%
% within Studyid	VARB	A	47.7%	52.8%	47.3%	48.7%
	VARB	B	52.3%	47.2%	52.7%	51.3%
	Total		100.0%	100.0%	100.0%	100.0%

In SPSS version 14, I had a script that did this. I cannot get it to work in 17, but is seems to me that this would be a standard option or at least commonly available. Does anyone have a way to do this as a default that can be turned off so I can revert to the standard output?

I also prefer means tables to be similarly formatted - which generally means switching the variables (row becomes column and column becomes row) and leaving statistics in the first dimension of row.

Melissa Ives

mives@...
voice: 309-451-7819

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at (309) 827-6026 for assistance.

« Return to Thread: Setting pivot table dimensions