Thanks for responding.
Row Area:
service type
1-2 days
3-9 days
10-30 days
30+

Column Area:
Nothing

Data Area:
Count of service area

The data is an Access crosstab query export

"Debra Dalgleish" wrote:

How is the pivot table set up? What fields are in the Row area, the
Column area, and the Data area?

What version of Excel are you using?

Gwen wrote:
Please assist
I have been unsuccessfully trying to figure out a way to get the column
totals for every change in service type.

Below is sample of the pivot table

service type 1-2 days 3-9 days 10-30 days 30+
st1 12 8 3 4
st1 3 4 5 4
st1 TOTAL

st2 5 7 9 3
st2 6 4 11 2
st2 total

Thanks


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html