Pivot table and filter based on cell value

[nburaq]

Hi Gents,
I have 3 pivot tables and I would like to filter 3 pivot tables based on year selected at cell value from drop down list. I think only way to do it with VBA or another method I found with slicers. (I dont want to use slicers due to visuality aspect) Any solution or tips for me? Thanks for your help and concern!

 

[GraH]

What's wrong with slicers?
With a few clicks, this default

becomes

If you want to avoid both slicers and VBA some sheet set-up is required. Or look at some of the stunning work of @Xlambda on APIVOT.

 

[nburaq]

What's wrong with slicers?
With a few clicks, this default
View attachment 67424
becomes
View attachment 67425

If you want to avoid both slicers and VBA some sheet set-up is required. Or look at some of the stunning work of @Xlambda on APIVOT.

Thanks GraH for the link. I will definitely check it!