View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andrea Andrea is offline
external usenet poster
 
Posts: 112
Default Pivot Table Subtotals

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