Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When dragging items into the Data field of the Pivot Table Layout wizard, I
have to double click on each item to change count to sum. I have data for 40-50 field buttons to add and Id like to know if there is a simple step to change all these fields to sum rather than double-clicking on each one individually. Ive noticed that sometime when I drag fields into the Data field, itll automatically Sum vs. Count. Not sure what causes this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - Count If | Excel Discussion (Misc queries) | |||
Pivot Table Count | Excel Discussion (Misc queries) | |||
Count within pivot table | Excel Worksheet Functions | |||
How do I use a pivot table to get an average count? | Excel Discussion (Misc queries) | |||
Count in Pivot Table | Excel Worksheet Functions |