Quick Question- VBA to swap Pivot Table Fields

largeselection

Active Member
Joined
Aug 4, 2008
Messages
358
Quick question-

I'd like to put in some code to swap the first field item in the row label section. I can do this by specifying the specific field I want to remove, but how can I get rid of the current "first field" if I don't know what it is?

So I might have my Row Labels as:

Name
State
Region
Product

I'd like to remove "Name" and add "ID" instead at the first spot. So I could do this via:

Code:
Dim pt As PivotTable
pt.ManualUpdate = True
    ActiveSheet.PivotTables("Users").PivotFields("Name").Orientation = _
        xlHidden
    With ActiveSheet.PivotTables("Users").PivotFields("ID")
        .Orientation = xlRowField
        .Position = 1
    End With

But now say I want to do the reverse?
Basically, is it possible to do something like...
Code:
    ActiveSheet.PivotTables("Users").PivotFields(1).Orientation = _
        xlHidden

to remove the first row field?
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
I could also alternatively be OK with removing ALL row fields and then just adding back the ones I didn't want to delete if that would make the process simpler.
 
Upvote 0

Forum statistics

Threads
1,214,622
Messages
6,120,585
Members
448,972
Latest member
Shantanu2024

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top