If I have a row label of product groups and vendors and want to know what the percentage of sales within each group is, how would I accomplish that?
If I do % of column for sales, it does it for the whole column. I want each subtotal to equal 100%.
Something like below but in pivot form.
Paper Products
Vendor A - 100k in sales - 50%
Vendor B - 50k in sales - 25%
Vendor C - 50K in sales - 25%
Total Paper Products - 200k in sales - 100%
Mops
Vendor D - 200k in sales - 67%
Vendor E - 50k in sales - 16%
Vendor F - 50K in sales - 17%
Total Paper Products - 300k in sales - 100%....
Thanks,
Roger
If I do % of column for sales, it does it for the whole column. I want each subtotal to equal 100%.
Something like below but in pivot form.
Paper Products
Vendor A - 100k in sales - 50%
Vendor B - 50k in sales - 25%
Vendor C - 50K in sales - 25%
Total Paper Products - 200k in sales - 100%
Mops
Vendor D - 200k in sales - 67%
Vendor E - 50k in sales - 16%
Vendor F - 50K in sales - 17%
Total Paper Products - 300k in sales - 100%....
Thanks,
Roger