custom tables question

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

custom tables question

Deirdre Nissenson Kurzweil
i am a new(er) user -- just upgraded to 14.0 and just completed
intermediate training. feeling a little overwhelmed, so if anyone can
help me, i'd REALLY be grateful...

current problem:
i'm trying to run a table of % agree for each of these 150 or so
attributes by division (% off division).
i created a subtotal for agree and hid the agree strongly/agree
categories, but i found when i excluded the other categories that i
don't want (neither, disagree, disagree strongly), the column % ended
up being 100%. the only way i can get the correct # for agree is to
keep all the categories represented (i guess it removes the
categories you're excluding from the base).

so, the way i'm getting what i want is to manually go in an delete
the unwanted rows (and moving the label up to the agree row).  see
attached output (exported into word) -- i've done this horribly
tedious exercsie for q8 and q9 already but the rest (starting at q10)
shows what i'm working with... then i have to do this all over again
for the net: disagree (needs to be in a separate table).

i'm sure there's got to be some simple way to do this!
Deirdre Nissenson Kurzweil
Market Research Manager
Publications and Marketing
Cornell University
353 Pine Tree Rd.
Ithaca, NY 14850

Email: [hidden email]
Phone: 607 254-5467