Pivot table not totaling

S

Shawn

Hello,

I am having problems getting a pivot table to total data together. The table
looks great for what I am doing but will not add the items together. It has
lines that say total but does not add the numbers up. The table appears like
this:

Item # Quantity
xxxx 1
xxxx 4
xxxx 10
xxxx total

aaaa 4
aaaa 4
aaaa total

I would like the table to add the quantity of each item # together. It would
be REALLY nice if I could have the total lines highlighted but I am not going
to push my luck.

Any help with this would be greatly appreciated.
Thanks,
Shawn
 
Top