Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Canberra, Australia, Australian Capital Territory, Australia
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Summary Function in Pivot Tables? (Excel 2k sr1)

    Hi,
    I'm trying to produce lots of graphs from a pivot table, using the sum summary function, but every time I change the data to graph, it defaults back to the count function.
    Is there a way to say what function to use by default?

  2. #2
    Star Lounger
    Join Date
    Apr 2001
    Location
    SOUTH AFRICA
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Summary Function in Pivot Tables? (Excel 2k sr1)

    HI DAVID

    If you record a macro to create your pivot tables (something like the first part of the coding), you can add the 2nd part of the coding which will always give you sum instead of count. The problem is that you want to a summary on the pivot table which is not a numeric field.

    Sheets("DETAIL").Select
    Range("FILTER_DATA").Select
    ActiveSheet.PivotTableWizard SourceType:=xlDatabase, SourceData:= _
    "DETAIL!FILTER_DATA", TableDestination:=Range("SUMMARY!A1"), TableName:="PivotTable1"
    ActiveSheet.PivotTables("PivotTable1").DisplayErro rString = True
    ActiveSheet.PivotTables("PivotTable1").AddFields RowFields:="MANUFACTURER"


    With ActiveSheet.PivotTables("PivotTable1").PivotFields (PIVDATA)
    .Orientation = xlDataField
    .Name = "SUM OF " & PIVDATA
    .Function = xlSum
    End With

    Hope this will help you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •