Use a variable to change pivot table filter

**dweingar** · 01-09-2019, 06:17 PM

I am trying to use a variable (Apple) to change pivot table filter to an account number on Client sheet. The first code generated by record button to change filter to account number 999421 works. The second is not changing the filter to the account number associates with variable "Apple". Any help would be appreciated.

Please Login or Register  to view this content.

**dflak** · 01-10-2019, 01:10 PM

You will probably have to loop through the values in the range Apple.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**rorya** · 01-10-2019, 01:11 PM

It would need to be:

Please Login or Register  to view this content.

**dweingar** · 01-17-2019, 04:58 PM

I am now receiving the following error: This item could not be found in the OLAP cube.

I updated the code and I pasted the value of Apple in cell 4,1 and notice that the value from "Sheets.Client" is formatted as a number and the value from the Pivot Table is formated as text, the original source is number format. Seems like the Pivot filter is converting data to text format. Not sure if this is issue.

Please Login or Register  to view this content.

**dweingar** · 01-17-2019, 05:42 PM

Here is file.

**rorya** · 01-18-2019, 04:20 AM

I missed an ampersand:

Please Login or Register  to view this content.

**dweingar** · 01-18-2019, 10:06 AM

Thank you for your help. I have spent a week trying to figure out how to filter a pivot table using a variable. I attached the working spreadsheet so hopefully this could help others.

**rorya** · 01-18-2019, 12:14 PM

Glad to help. Thanks for the rep and kind words!

Use a variable to change pivot table filter

LinkBack

Thread Tools

Rate This Thread

Display

Use a variable to change pivot table filter

Re: Use a variable to change pivot table filter

Re: Use a variable to change pivot table filter

Re: Use a variable to change pivot table filter

Re: Use a variable to change pivot table filter

Re: Use a variable to change pivot table filter

Re: Use a variable to change pivot table filter

Re: Use a variable to change pivot table filter

Thread Information

Users Browsing this Thread

Similar Threads

Pivot table filter with variable

Problem trying to use variable to filter pivot table.

Pivot Table to Filter using a variable

Change Pivot Table Filter Based on Cell Value when Pivot Table is from an external Databas

Automatically filter Pivot Table using a variable

Pivot table, assigning a cell wo be change the Pivot table filter

Change Pivot table Filter Based on Cell Value Multiple Filter items Possible?

Bookmarks

Bookmarks

Posting Permissions