Show Detail in Pivot Table

[Birinder]

Hi,

I have a Pivot table which shows Volume and % of each customers. I Have a macro that goes by each customers one by one, and prints out the information on a pdf file for each individual pivot values for each customer.

My issue is that my customers also want to include data that is only related to them. I can get the data by right clicking on Show detail, but not sure how to add it in my macro, so that it also gets prints out in a separate file.

I am uploading the file, there is no sensitive data. I am looking for detail get printed out automatically as shown on tab Sheet1.

Thanks everyone,

Birinder

 

[Hui]

  Range("G7").Select
  Selection.ShowDetail = True

 

[Birinder]

  Range("G7").Select
  Selection.ShowDetail = True

Thanks, I am not good with VB Macro coding ,, would you please show me where in my code I include this :

Range("G7").Select
Selection.ShowDetail = True


Thanks again,

Birinder

 

[Birinder]

I want to save the detail for each customer on a PDFs format, and saved with customer's name and today's date.