filter in workbook

Hi,

I have a simple workbook, skup as X, measures as Y, i have 3 measures A, B, C in the workbook, their base intx are skup.

Now i want to hide all skups when C != "Y" when the workbook is opened.

I can't use PQD since i do not have Z.

I do not want to use pre-Range mask either, because i do want to bring everything into the workbook, i just want to auto hide skups when C != "Y"

Is this doable?

Thanks.