Pivot Table Report Filter using VBA

Question

I am trying to automate a particular Pivot table filtering using VBA. I am not sure how to add "Report Filter" (please see attached screen shot) using VBA.

To automate the process, I got the code for adding rows , columns and values , but can't seem to find the code for report filter.

Can you please help me out with the code for this.

Filter

Report Filter

best way to check how to do anything - record a macro and you will see — avb
– avb, Commented Sep 15, 2017 at 19:13
@braX I need a code for pivot table to add Report Filter. Eg. We can add pivot tables manually and apply/insert 4 basic properties namely filters, Columns , Rows and summation value(See attached image). To automate the process, I got the code for adding rows , columns and summation values , but can't seem to find the code for report filter. Can please help with that? — Prashant Jain
– Prashant Jain, Commented Sep 17, 2017 at 20:07

Prashant Jain · Accepted Answer · 2017-09-25 14:46:20Z

1

Thanks @avb for the suggestion . Recording the macro helped. The code for adding pivot report filter is this.

    Sub pivotReportFilter(ptUse As PivotTable, fName As String)

     With ptUse.PivotFields(fName)
      .Orientation = xlPageField
      .Position = 1
     End With

   End Sub

answered Sep 25, 2017 at 14:46

Prashant Jain

214 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pivot Table Report Filter using VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related