How do i filter a pivot based on my Dropdown selection.

[Shraddha]

Please advice as i am trying to filter the pivot table in table PT1 based on selection made in dropdown of Report tab.
this is a sample file

 

[Shraddha]

any help on this ?

 

[GraH - Guido]

Why not simply use a slicer?
If you are after a VBA solution, then this thread should move to the VBA section.

 

[Shraddha]

Yes I am looking for something that will help me filter based on selection made by combobox

 

[GraH - Guido]

Your code works with this small tweak

With ThisWorkbook.Worksheets("PT1").PivotTables("PivotTable1").PivotFields("Customer")
        .CurrentPage = Target.Value2
 End With

 

[Shraddha]

Actually I was looking to edit using the combo box. Please see attached

 

[Shraddha]

The challenge is I am unable to reference the drop down box from form controls

 

[vletm]

Shraddha
Why did You opened a new thread?

How do i filter my pivot using combox and get the desired result in VBA.

attached file for reference

chandoo.org

... or how would that be different than Your #6 -file or Your 'actually' needs?

 

[Shraddha]

@vletm
Yes #5 has a dropdown that I am using which is a form control. I need to filter my pivot based on that. Previously I had share a list box created in data validation.

 

[vletm]

Shraddha
Do You need both?
As You wrote #6 Reply Actually I was looking to edit using the combo box.

Now You have two 'same thread' open ... hmm?

Shraddha
Other thread closed now - no duplicates.
No need to send same file many times.

 

[Shraddha]

I need to be able to filter pivot using the form control combo box

 

[Shraddha]

Any help will be much useful... I am not sure why its not working