Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I rarely use count in my pivot tables, is there a setting I can change in
excel so that when I select my values, which is usually 5 or more, I have to reset to sum instead of count. It's extremely time consuming and very frustrating. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to set Excels pivot data as default SUM instead of COUNT | Setting up and Configuration of Excel | |||
Can I change subtotal default settings from count to sum, for exam | Excel Discussion (Misc queries) | |||
pivot table data field defaults to COUNT, would like it to default toSUM | Excel Discussion (Misc queries) | |||
Pivot Table Default - Count to Sum | Excel Discussion (Misc queries) | |||
Pivot Table: I want default to be sum & not count | Excel Worksheet Functions |