Filter power pivot rows by multipile values

[BORUCH]

Hi all

I have a pivot table that has the customer NUMBER in the row section

I would like a vba code that I can filter the customer no. by multiple customer NO. ,entered on a different cell in the worksheet. It is very time consuming to select multiple customer numbers in the pivot filter list

 

[Matt Allington]

Is there some logic to the customers you want to filter? Why not add the grouping to the customer table and use that to filter instead?

 

[BORUCH]

Is there some logic to the customers you want to filter? Why not add the grouping to the customer table and use that to filter instead?

there is no particular logic it can any list of customer # like
cust# 123
cust#456 etc.

 

[BORUCH]

there is no particular logic it can any list of customer # like
cust# 123
cust#456 etc.

any updates i would greatly appreciate it

i'm using excel 2016

 

[Matt Allington]

If you are after VBA, you would be better to post to a VBA forum. The pivot table is unrelated to power pivot.

 

[ImkeF]

Maybe one of the techniques described here will suit you: Want to filter a PivotTable based on an external range or list? – The BIccountant