+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Macro: Σ Values Defaults in Row Label, Need to move it to Column Label

  1. #1
    Registered User
    Join Date
    09-27-2013
    Location
    MA, US
    MS-Off Ver
    Excel 2007
    Posts
    2

    Pivot Table Macro: Σ Values Defaults in Row Label, Need to move it to Column Label

    With this Macro, I need the "Σ Values" to be in the Column Label, but I can't figure out how to move it.


    Private Sub CommandButton1_Click()

    Sheets("Pivot").Cells.EntireColumn.Delete

    ActiveSheet.Range("A1").Select
    Set objtable = ActiveSheet.PivotTableWizard(TableName:="PT1", TableDestination:=Sheets("Pivot").Cells(2, FinalCol + 2))

    With Sheets("Pivot").PivotTables("PT1")
    With Sheets("Pivot").PivotTables("PT1").PivotFields("BalAmt")
    .Orientation = xlDataField
    .Function = xlSum
    .NumberFormat = "$ #,##0"
    .Position = 1
    End With
    With Sheets("Pivot").PivotTables("PT1").PivotFields("BalAmt")
    .Orientation = xlDataField
    .Function = xlSum
    .NumberFormat = "$ #,##0"
    .Position = 2
    End With
    With Sheets("Pivot").PivotTables("PT1")
    .AddDataField ActiveSheet.PivotTables("PT1").PivotFields("BalAmt")
    End With

    With Sheets("Pivot").PivotTables("PT1").PivotFields("Rcv Owner")
    .Orientation = xlRowField
    End With
    End With

    End Sub

  2. #2
    Registered User
    Join Date
    09-27-2013
    Location
    MA, US
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Pivot Table Macro: Σ Values Defaults in Row Label, Need to move it to Column Label

    Help.jpg

    Please help, I've search up and down for a solution. I tried using a pivotcache method too with the same result.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 11
    Last Post: 07-18-2013, 05:14 PM
  2. Filter Pivot Table Row Label by Another Row Label
    By bdcelli in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-14-2013, 12:57 PM
  3. Linking column label in Pivot table
    By James_SF in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2011, 10:55 AM
  4. Ling column label in Pivot table
    By James_SF in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2011, 03:10 PM
  5. How to delete column label from pivot table field
    By Evy Lum in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-27-2006, 09:15 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1