pivot tables

  • Thread starter Thread starter bichteler
  • Start date Start date
B

bichteler

hi!

does anybody know how to set certain Pivot field settings as default?

The problem:
when i add a colum to my pivot table it shows me the count of each value
instead of the sum.
so i change it manually from count to sum. when i now remove that specific
colum and add it later on again, it
lost the setting and shows me again the count and not the sum.

please help.

florian
 
It will do this automatically any time you have blanks or text within your
data. Either fix the source data, or assign a routine to a shortcut that
changes it for you, eg:-

Sub MakeAllSum()

Dim pf As PivotField

For Each pf In ActiveSheet.PivotTables(1).DataFields
pf.Function = xlSum
Next pf

End Sub

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
Back
Top