I have a question about that macro. When I tried using it, it hides all items in a pivot table EXCEPT the last item (I am assuming because you must be showing at least one item?). Is there a way around this?