# Percent of Pivot Table Question

#### rconverse

##### Well-known Member
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

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### sr12345

##### Active Member
Which version of Excel are you using?

Do you have the ability to add a column to the data set?

#### rconverse

##### Well-known Member
2007

I could, but I kind of need it to be dynamic so if I change the row sources, I can still produce a percentage of subtotals.

#### sachavez

##### Active Member
This will work for Excel 2007

Pull your sales numbers into the values field
set the value settings as a "% of Total"

Let us know if that works.

#### sachavez

##### Active Member

This will work for Excel 2007

Pull your sales numbers into the values field
set the value settings as a "% of Total"

Let us know if that works.

Excel Workbook
ABCD
3Values
4SHIPPERPRICE AUTHORITYSum of UNITS% of Total
5TOYOTAMOTSAL35062240.07%
69002020.01%
7111123240.07%
811196510.00%
91121285861.75%
101123006842.05%
11147201270.08%
123009962510375.09%
1330711310.00%
14307191656819.65%
15TOYOTAMOTSAL Total3302098.77%
16TOYOTATSUAME940024071.22%
1711133220.01%
1830511630.01%
19TOYOTATSUAME Total4121.23%
20Grand Total33432100.00%
Sheet5

#### rconverse

##### Well-known Member
Thanks but I'm looking for both of your Toyota group's percent of sales that tallies to 100%.

#### bigalkesn

##### New Member
I am looking to do the same thing, the percent of subtotals. Have you found an answer yet?

Scot

#### sachavez

##### Active Member
Scot,

I could not find a solution and moved on to conquer a bigger rock.

Steve

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,186
Messages
5,835,886
Members
430,392
Latest member
bongouni553

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back