Filter Pivot Table Column

[Exceladd1ct]

Hello,

I am trying hide the rows in Pivot Table where color Blue has no QTY/ empty cell.

Any suggestion please?

Thank you.

 

[mrshl9898]

You could add a label filter on Color for Black.

 

[Exceladd1ct]

You could add a label filter on Color for Black.


View attachment 40959

Hello and thanks.

True, the label filter could do the job in this case, but I am interested in hiding rows by empty cell criteria on some color column since my original PT has way more data.

Any other suggestions?

 

[mrshl9898]

VBA to hide the rows

 

[Exceladd1ct]

VBA to hide the rows

Yes, I was afraid this is the only solution. I was hoping I can keep this WB macro-free.
I will do it by vba.

Thanks for your support.