Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table Field Settings
I am using Excel 2003. When I pivot data, I frequently do not want the
automatic sub-total for the fields. Can I change the default sub-total field setting to "None", instead of "Automatic"? It's kind of a pain to constantly change the field setting everytime I move data around. |
#2
|
|||
|
|||
I don't know of a way to change the default setting for subtotals. After
you've created the pivot table, you could use a macro to turn them off. There's code to do that in my pivot table add-in, that you can download he http://www.contextures.com/xlPivotAddIn.html Pivot Novice wrote: I am using Excel 2003. When I pivot data, I frequently do not want the automatic sub-total for the fields. Can I change the default sub-total field setting to "None", instead of "Automatic"? It's kind of a pain to constantly change the field setting everytime I move data around. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
That's AWESOME!
Thanks a lot. "Debra Dalgleish" wrote: I don't know of a way to change the default setting for subtotals. After you've created the pivot table, you could use a macro to turn them off. There's code to do that in my pivot table add-in, that you can download he http://www.contextures.com/xlPivotAddIn.html Pivot Novice wrote: I am using Excel 2003. When I pivot data, I frequently do not want the automatic sub-total for the fields. Can I change the default sub-total field setting to "None", instead of "Automatic"? It's kind of a pain to constantly change the field setting everytime I move data around. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
You're welcome! I hope it helps.
Pivot Novice wrote: That's AWESOME! Thanks a lot. "Debra Dalgleish" wrote: I don't know of a way to change the default setting for subtotals. After you've created the pivot table, you could use a macro to turn them off. There's code to do that in my pivot table add-in, that you can download he http://www.contextures.com/xlPivotAddIn.html Pivot Novice wrote: I am using Excel 2003. When I pivot data, I frequently do not want the automatic sub-total for the fields. Can I change the default sub-total field setting to "None", instead of "Automatic"? It's kind of a pain to constantly change the field setting everytime I move data around. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
Wow, that's great! Thanks for your hard work and sharing it with us!!!!!
"Debra Dalgleish" wrote: I don't know of a way to change the default setting for subtotals. After you've created the pivot table, you could use a macro to turn them off. There's code to do that in my pivot table add-in, that you can download he http://www.contextures.com/xlPivotAddIn.html Pivot Novice wrote: I am using Excel 2003. When I pivot data, I frequently do not want the automatic sub-total for the fields. Can I change the default sub-total field setting to "None", instead of "Automatic"? It's kind of a pain to constantly change the field setting everytime I move data around. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#6
|
|||
|
|||
You're welcome!
Ngan wrote: Wow, that's great! Thanks for your hard work and sharing it with us!!!!! "Debra Dalgleish" wrote: I don't know of a way to change the default setting for subtotals. After you've created the pivot table, you could use a macro to turn them off. There's code to do that in my pivot table add-in, that you can download he http://www.contextures.com/xlPivotAddIn.html Pivot Novice wrote: I am using Excel 2003. When I pivot data, I frequently do not want the automatic sub-total for the fields. Can I change the default sub-total field setting to "None", instead of "Automatic"? It's kind of a pain to constantly change the field setting everytime I move data around. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
caluclated field in pivot table? | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Pivot Table - Default Settings for Table Options | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |