S Shraddha New Member Feb 9, 2020 #1 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
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
GraH - Guido Well-Known Member Feb 9, 2020 #3 Why not simply use a slicer? If you are after a VBA solution, then this thread should move to the VBA section.
Why not simply use a slicer? If you are after a VBA solution, then this thread should move to the VBA section.
S Shraddha New Member Feb 9, 2020 #4 Yes I am looking for something that will help me filter based on selection made by combobox
GraH - Guido Well-Known Member Feb 9, 2020 #5 Your code works with this small tweak Code: With ThisWorkbook.Worksheets("PT1").PivotTables("PivotTable1").PivotFields("Customer") .CurrentPage = Target.Value2 End With
Your code works with this small tweak Code: With ThisWorkbook.Worksheets("PT1").PivotTables("PivotTable1").PivotFields("Customer") .CurrentPage = Target.Value2 End With
S Shraddha New Member Feb 9, 2020 #6 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
S Shraddha New Member Feb 9, 2020 #7 The challenge is I am unable to reference the drop down box from form controls
V vletm Excel Ninja Feb 9, 2020 #8 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 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?
S Shraddha New Member Feb 9, 2020 #9 @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 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.
V vletm Excel Ninja Feb 9, 2020 #10 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: Feb 9, 2020
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.
S Shraddha New Member Feb 9, 2020 #11 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
S Shraddha New Member Feb 9, 2020 #12 Any help will be much useful... I am not sure why its not working