Pivot table with customer sales data, into an individual report with specific rows

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

I want the generated report to show AF AG AH AB AZ AK AA Z AJ I J K L columns.

One other thing. It doesn't have to be done by double clicking and expanding the data. If there is another simple or easy way to do it, I would appreciate it.


Attachment 285191