• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

Shraddha

New Member
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
 

Attachments

  • filterPivotTable with Drop Down List to Filter_test.xlsm
    21.6 KB · Views: 2
Why not simply use a slicer?
If you are after a VBA solution, then this thread should move to the VBA section.
 
Your code works with this small tweak
Code:
With ThisWorkbook.Worksheets("PT1").PivotTables("PivotTable1").PivotFields("Customer")
        .CurrentPage = Target.Value2
 End With
 
Actually I was looking to edit using the combo box. Please see attached
 

Attachments

  • GetPivotData with COMBO List to Filter_Test.xlsm
    25 KB · Views: 0
@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.
 
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.
 
Last edited:
I need to be able to filter pivot using the form control combo box
 

Attachments

  • GetPivotData with COMBO List to Filter_Test.xlsm
    25 KB · Views: 6
Back
Top