Pivot table

  • Thread starter Thread starter =?iso-8859-1?B?QW5kcuk=?=
  • Start date Start date
?

=?iso-8859-1?B?QW5kcuk=?=

I asked this yesterday but I am having difficulty getting
to my original post. Page 1 of this news group keeps
brining me to feb 17th.... anyways this is what i asked
yesterday:
Is there a way I can set up a pivot table with sub
categories? i.e. Type of Contact is my heading and under
it I have 4 categories (phone, walk-in, etc...)

Thanks.

A.

I got this reply:
If you add Type of Contact to the row area, you should see
all of the
categories. Can you describe the fields in your data
table, and how
you'd like them to appear in the pivot table?

My answer to this is:
I would like my headings and their subcategories on the
left, i'd like my months to span the top and the #'s data
in the middle. To give a better example this is what I'd
like it to
look like.

Type of Contact
- Phone Call
- Walk In
- Email
- etc...

Consultation Type
- New Start-Up
- New Existing
- so on and so forth...


A.
/longest post ever!
 
Yesterday, you posted your question in the excel.worksheet.functions
newsgroup, so that's why you can't find it today. I posted the following
reply there:

'========================
If you add 'Type of Contact' and 'Consultation Type' to the row area,
the headings would either be (depending which field is first in the row
area):

Phone Call New Startup
New Existing
Walk In New Startup
New Existing
etc.

OR

New Startup Phone Call
Walk In
Email
New Existing Phone Call
Walk In
Email
etc.
'=====================================
 
Back
Top