Pivot Table

[André]

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.

 

[Debra Dalgleish]

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?

 

[André]

Sorry for the delay.

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.

A.

 

[André]

Sorry 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...

 

[Debra Dalgleish]

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.