Pivot tables and total count

  • Thread starter Re: Pivot Table/Query
  • Start date
R

Re: Pivot Table/Query

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?
 
B

Bernie Deitrick

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
 
Top