how come you have two st1 in a pivot table? are you sure they are typed
exactly the same in the source data? Or you have one more row field not shown
in the example?


"Gwen" wrote:

Yes, I did and put a row count for each service type in a total column next
to the 30+ column.
Thanks

"Andrea" wrote:

did you try to select "service type" (any item or the heading) right click,
select field setting and in the pop up windows select custom and the kind of
subtotal you like?

"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