How do you build a pivot table with sub column % of totals?

[meglan]

Hey all-
I'm hoping someone can help me. I've built a pivot table with rows that are sales team member names. It also includes columns with product names and sub columns that show years. I have all of the numbers there,but I can't change the values to percent of total I am looking for. I want to see the distribution of product per sales person per year. I want to see the overall percentage of each product sold, but I also want to see by year. For example, if 25% of Tom Jones' sales came from product 1(for all 3 years) what was the percentage in 2016, 2017, and 2018. The use percentage of total rows or columns doesn't seem to work because I just want to see the percentage for within the year.

Any help would be greatly appreciated.Thank you!

Meg

 

[sheetspread]

Can you post a sample file on dropbox? It needn't have the same info or size, just structure.