The data may look like this:
SKU Region #s sold
100 1 1000
100 2 5000
100 3 4000
101 1 3000
102 2 500
102 5 500
103 1 1000
103 2 1000
103 4 3000
I need it to calculate the pct of total for each SKU.....first I can subtotal by SKU to get the totals, but then I'd have to manually add a column of formulas to calculate %
Final data would look like this
SKU Region #s sold Pct of SKU
100 1 1000 10%
100 2 5000 50%
100 3 4000 40%
101 1 3000 100%
102 2 500 50%
102 5 500 50%
103 1 1000 20%
103 2 1000 20%
103 4 3000 60%
SKU Region #s sold
100 1 1000
100 2 5000
100 3 4000
101 1 3000
102 2 500
102 5 500
103 1 1000
103 2 1000
103 4 3000
I need it to calculate the pct of total for each SKU.....first I can subtotal by SKU to get the totals, but then I'd have to manually add a column of formulas to calculate %
Final data would look like this
SKU Region #s sold Pct of SKU
100 1 1000 10%
100 2 5000 50%
100 3 4000 40%
101 1 3000 100%
102 2 500 50%
102 5 500 50%
103 1 1000 20%
103 2 1000 20%
103 4 3000 60%