Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick pivot table question
This one is much simpler. Whenever i create pivot tables (and i create a lot)
I want to work with the Sum function 99% of the time. However, it always defaults to 'Count'. then, when I change the field settings it forces me to do each one individually. So, my question is one, can you set it so it defaults to sum? Or two, can you do a multiple line field setting change? Thanks again. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick pivot table question
You can't change the default settings for the data fields. If a field
contains blank cells, or cells with text, it will default to COUNT. Otherwise, it will SUM. There's a feature that changes all the data fields to SUM, in the pivot table add-in that you can download he http://www.contextures.com/xlPivotAddIn.html The Joe wrote: This one is much simpler. Whenever i create pivot tables (and i create a lot) I want to work with the Sum function 99% of the time. However, it always defaults to 'Count'. then, when I change the field settings it forces me to do each one individually. So, my question is one, can you set it so it defaults to sum? Or two, can you do a multiple line field setting change? Thanks again. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick Question - Pivot Table Data | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table Problems | Excel Discussion (Misc queries) |