Handling Value Field Settings in a Pivot Table

[VKS]

Hello Experts,

Need your expertise in doing something more professionally if it can be done from experts point of view.

My problem is a pivot table where I would like to see %ages in the value cells for each sales person for each product. I am not too sure if I can explain this properly hence attaching one sample excel showing how it looks and how I would want it to look.

Currently to achieve my goal I take the product up to report filter and select products one by one by selecting show value as % of total (Please see I have more than 45 products which makes it 45 worksheets).

Thanks/VKS