ExcelBanter - Pivot tables and total count

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot tables and total count (https://www.excelbanter.com/excel-worksheet-functions/44956-pivot-tables-total-count.html)

Pivot Table/Query

Pivot tables and total count

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?

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

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

All times are GMT +1. The time now is 02:45 PM.