| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percent of total in Pivot tables | Excel Worksheet Functions | |||
| Pivot tables | Excel Discussion (Misc queries) | |||
| Average of count in pivot tables | Excel Worksheet Functions | |||
| Pivot Tables - "simple" question | Excel Discussion (Misc queries) | |||
| Total two pivot tables into one | Excel Worksheet Functions | |||
Linear Mode
