Pivot Table (with filter) Does Not Refresh

[jbeanx80]

Hello!

I have a pivot table with two filters. The first filter encompasses multiple items denoted with an * at the end (M17002*), the second filter generally has a specific item (63266-A). Without the filters, the pivot table updates upon hitting the refresh button, however WITH the filters set, it does not. I have multiple sheets with the same pivot table format that feeds off of the same data. Is there a way to have the pivot table update?

Any help will be greatly appreciated!
Thank you in advance!

 

[Alex Blakenburg]

Unfortunately to do what you want you either need to add a helper column to your data or move PN from the Page Filter position to the Row position.
In the Row position you can add a Label filter and select Begins With M17002

In the Page filter position your M17002* effectively filters what is available for selection in the drop down and puts a tick against what is available at that time.
When you add a new M17002 prefix value, it wasn't there at the time the previous action ticked it so it appears unticked in the refreshed pivot table.

 

[jbeanx80]

Unfortunately to do what you want you either need to add a helper column to your data or move PN from the Page Filter position to the Row position.
In the Row position you can add a Label filter and select Begins With M17002

In the Page filter position your M17002* effectively filters what is available for selection in the drop down and puts a tick against what is available at that time.
When you add a new M17002 prefix value, it wasn't there at the time the previous action ticked it so it appears unticked in the refreshed pivot table.

Thank you for the suggestion, but I'm still hitting a snag.

This time I left Spec on the Page Filter (63266-A), removed PN (M17002*), and added a label filter on my helper column in Row Labels to Begin With M17002. It seems like as long as I have the Page Filter, it won't let me update.

Is there a way in Label Filters, under "Contains," set multiple criteria (ie "M17002*" & "63266-A")?

Thanks.

 

[Alex Blakenburg]

Sadly you are going to have the exact same issue with the Spec field.
Your initial selection meant that "63266-A" would have captured all, but your added items have Spec as "FTOD/63266-A" which means that you need Contains or Ends With.
This is only available at the Row level under Label Filters.

 

[jbeanx80]

Is there another way to derive at the same results as I'm looking for?

 

[Alex Blakenburg]

Only either have a helper column or put it in the Row area and use a custom filter.