Pivot sub filters not limiting search

[Zealotwraith]

Good day,

I have a pivot table with different department and the building # that corresponds to them

however when I filter department, it doesn't restrict the dep building filter to only those buildings,

it still shows me all the buildings,

Example. if i set the department to dep 1,

buildings should only show 2011, 2014, 2015, 2019

test 1.xlsx

[JosephP]

correct-pivot table filters do not work the same as autofilter filters unfortunately

[Zealotwraith]

Face palm,

thanks,