Well, I figured out the answers to #1 and #2. #3 is a minor issue.

But I'm just realizing that I can't sort the records in the pivot table.
And even when I sort the records in the main worksheet and then refresh the
pivot table, the pivot table doesn't sort like the main sheet. Is there a
way to sort data without having to create the pivot table all over again
(I've spent two hours formatting it)?

Thanks --

Chris


"crcurrie" wrote:

Thanks, again -- Max! Now I'm really getting there. A few last qq.:

1. How can I change the positions of the data columns?
2. Is there any way to add more columns to the pivot table, after I've
already formatted it? (I can't seem to get back to that window that allows me
to add rows and columns.)
3. Is there any way to eliminate the "(blank)" values in the null data
fields, so that those cells just show as empty?

Chris

"Max" wrote:

Double-click on the gray field names,
then just select "None" for Subtotals OK
(default is Auto)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"crcurrie" wrote:
Thanks, Max -- I'd always wondered what a "pivot table" was!

One more problem, though: I have a number of other fields besides name for
each record (address, phone, etc.). When I create the pivot table, it does a
subtotal for each additional column, each calculation constituting an
additional row. So I end up with this really long, ungainly worksheet. ANy
way to turn off the subtotaling and just have the one row per record?

Chris