Calculating a percentage of two columns in a pivot table

[Barneyxcl]

Hi There,

I've looked everywhere for the answer to this - I'm not sure if this is something glaringly obvious or I'm searching incorrectly through the forums/google

So - I have a pivot table that is pulling data from another table. Within the pivot table there are two columns - sum of leads and sum of opportunities as follows:

Leads Opps Percentage opps?
100 5
235 8
754 13
363 87

These are pivot table columns pulling data from another source. How can I add another column next to these that tells me the percentage of opps to leads? So a column that tells me that 5 is 5% of 100 in column A.

Your help is much appreciated - as you can see I'm pretty new with pivots

Many Thanks
Barney

 

[AhoyNC]

To add another column to your pivot table (Excel 2007 or 2010).

Click in your pivot table.
You should see Pivot Table Tools in the ribbon.
1.- Click on Options
2.- Go to Fields, Items, Sets
3.- Go to option for Calculated Field
You then can add your % field.

 

[Barneyxcl]

AhoyNC - you are awesome. Thanks buddy this was a big help

Barney

 

[fadetograham]

This was exactly what I needed, identical scenario so thank you both!

And just like Barney I am brand new to creating pivot tables

Cheers
Graham

 

[jfkexcel]

To add another column to your pivot table (Excel 2007 or 2010).

Click in your pivot table.
You should see Pivot Table Tools in the ribbon.
1.- Click on Options
2.- Go to Fields, Items, Sets
3.- Go to option for Calculated Field
You then can add your % field.

But how exactly do I do that? Thanks.

 

[AhoyNC]

What are you trying to do and what issue are you having? Also what ver. of Excel are you using.
If you just want a % field, another way is.
Build your Pivot Table and add the field you want to be a percent.
Then:
1.=Right click on field.
2.-Choose Value Field Setting.
3.-Show Value AS.
4.Choose what you want from the drop down.

 

[dconnors]

I can't figure this out after reading & searching for about 45 minutes. If someone can direct me to the correct place that would be great. I have Excel 2016.

I'm trying to create a column that has a percent of column date presented to the count of total clients for each employee

I have a count for each employee for their total clients, the total client info entered, the total reviewed, and total presented to client.
I've done ='Date presented to Client'/'Total #' as the formula but end up with #DIV/0!. I want to end up with 3.448% and 10.5% for the two employees with presentations.

I've tried several things with the same result and my googling skills are apparently pretty poor since I've found nothing on this specifically.

Count of Total #	Count of Data Loaded

<tbody>
[TD="width: 162"]Count of Date Reviewed[/TD]
[TD="width: 220"]Count of Date presented to Client[/TD]
[TD="width: 102"]Count of Field1[/TD]

[TD="align: right"]36[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]#DIV/0![/TD]

[TD="align: right"]26[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]#DIV/0![/TD]

[TD="align: right"]13[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]#DIV/0![/TD]

[TD="align: right"]29[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]#DIV/0![/TD]

[TD="align: right"]44[/TD]
[TD="align: right"]6[/TD]

[TD="align: center"]#DIV/0![/TD]

[TD="align: right"]38[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: center"]#DIV/0![/TD]

</tbody>