The pivot table should have a grand total for every field, whether it is a count or a sum. Just
make sure that you have Grand Totals for Columns checked under your table options.

HTH,
Bernie
MS Excel MVP


" Pivot Table/Query" wrote in message
...
I am pretty familiar with pivot tables. I have fields that are counting, and
fields that are summing. In my primary field I am summing and counting. How
can I get the grand total to count and sum?