VBA: Filter Pivot Table based on cell values

Hello,

I'm having some trouble filtering Row Labels based on cell values since I am not able to use .CurrentPage since this seems to only apply for Report Filter. I have three fields in Row Labels and just one field in Values, basically I want to be able to filter the pivot table from another sheet depending on three different cell values.

Reason why I dont have the fields in Report Filter but in Row Labels is that I still want to see all the rows in the pivot, not only the total sum (to be able to create charts later on or automatically).

Would very much appreciate your help on this one since I havent found any solution on this forum and google.

Br,
Nicklas

Hi Nicklas,

Could you upload a sample workbook without any sensitive data and explain expected result? Would be easier for us to work with

Mvh,
Johan

Sure! Find enclosed the example. I'm trying to figure out if it's possible to Filter as single selection from the yellow marked cells, with the fields still as RowLabels and not in Report Filter.