Is it possible to have a macro to execute when clicking on the pivot table show information? So lets say I have 2 columns on my pivot table Column A - Customer name Column b Total sales. When I click on total sales it creates a break down of what the customer purchased. I want to make the report only show certain columns in a certain order.

Thank you