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
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