The column headers are weeks. There are 10 data fields that are just counts
of call results. The grand totals for columns isn't working for some reason.

Date
5/4/10 - 5/11/10 - 5/18/10 - 5/25/10 -
6/1/10 -
Data 5/10/10 5/17/10 5/24/10 5/31/10
6/5/10
No Answer 2 1 5 6
Left Message 3 0 2 4
Inactive 1 3 3 5
Not Interested 5 0 7 4
Callback

Thanks

"Jim Thomlinson" wrote:

I do not understand the question. If all you have is column headers and data
fields then what are you trying to add up. Each field will only have one row
of data so there is nothing to total unless you wanted to aggregate the
values of the different fields. If that is the case then you need to use a
calculated field to aggregate as the pivot table will not aggregate different
fields by default.

By way of an expanation fields would typically be different measures like
Units Dollars and Weight. You would not add all of those things together as
it makes no sense.
--
HTH...

Jim Thomlinson


"Nate" wrote:

I have a pivot table that only has column header and data fields - no row
area. I would like it to show totals for each column, but nothing happens
when I check Grand Totals for Columns in the table options menu?