Date:         Thu, 15 Mar 2012 19:12:29 -0600
Reply-To:     Jon K Peck <peck@us.ibm.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Jon K Peck <peck@us.ibm.com>
Subject:      Re: modifying default cell properties for pivot tables
Comments: To: "Parise, Carol A." <PariseC@sutterhealth.org>
In-Reply-To:  <AFAB3BDD6FA022468ED594D954E35518194DA2C1F7@DCBL101VX.root.sutterhealth.org>
Content-Type: multipart/alternative;

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
peck@us.ibm.com
new phone: 720-342-5621




From:   "Parise, Carol A." <PariseC@sutterhealth.org>
To:     SPSSX-L@listserv.uga.edu
Date:   03/15/2012 05:53 PM
Subject:        Re: [SPSSX-L] modifying default cell properties for pivot
tables
Sent by:        "SPSSX(r) Discussion" <SPSSX-L@listserv.uga.edu>



I'm using version 20. I see now that #2 was the format for the "Case
processing Summary  not the actual crosstabs table.

For #1. Where is the digit grouping preference found?
>>Edit > Options > General

From: Jon K Peck [mailto:peck@us.ibm.com]
Sent: Thursday, March 15, 2012 4:16 PM
To: Parise, Carol A.
Cc: SPSSX-L@listserv.uga.edu
Subject: Re: [SPSSX-L] modifying default cell properties for pivot tables

For #1, if you have V20 or maybe it was V19, you can just set a preference
item for using digit grouping.  No tableLook involved.

Since #2 is not a known format for pivot tables, you would have to use
scripting directly or with SPSSINC MODIFY TABLES to change the % items to
use parentheses (unless you are going to edit each cell by hand :-( )

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
peck@us.ibm.com
new phone: 720-342-5621




From:        "Parise, Carol A." <PariseC@sutterhealth.org>
To:        SPSSX-L@listserv.uga.edu
Date:        03/15/2012 04:47 PM
Subject:        [SPSSX-L] modifying default cell properties for pivot
tables
Sent by:        "SPSSX(r) Discussion" <SPSSX-L@listserv.uga.edu>




I have what I hope is an easy question for someone.

I'm changing the default look of my pivot tables and there are two things
I would like to do:

1) Display the commas in numbers i.e. 1,200 versus 1200
2) Add parentheses in around the percents in a crosstabulation table. The
format 'Academic' displays the frequencies and percents just how i would
like them to i.e. 20 52% but i would like to have them look like this 20
(52%)


It is easy to do #1 above by clicking on cell properties but I haven't
figured out how to make this 'stick' as the default table format. When i
go into TableLooks, i don't have the option of a cell properties box.

thanks
Carol




[text/html]