pivot-CalcField-Example-r1.xls

<div>
Thanks dlmille. &nbsp;But Column 1 and Column 2 are Pivot sums already, how do I calculate on these calculated columns? 
</div>


Thanks dlmille.  But Column 1 and Column 2 are Pivot sums already, how do I calculate on these calculated columns?

<div>
maybe there are some missing details... Column 1 and Column 2 are Counts of the original field. <br />
<br />
The actual sheet has columns:<br />
Table Name, Approved.<br />
<br />
The pivot table has:<br />
Count of Table Name, Count of Approved<br />
<br />
The column I want to add is:<br />
Approved Percentage, &nbsp;wihch should have a formular (count of approved / count of table name). &nbsp;<br />
<br />
I can't seem to get it working... please help. <br />

</div>


maybe there are some missing details... Column 1 and Column 2 are Counts of the original field.

The actual sheet has columns:
Table Name, Approved.

The pivot table has:
Count of Table Name, Count of Approved

The column I want to add is:
Approved Percentage,  wihch should have a formular (count of approved / count of table name).  

I can't seem to get it working... please help.


<div>
<div class="content wysiwyg-content">
I have this pivot table, very simple, column 1 and column 2 each hold a count of something. &nbsp;I need to add a column so that I can calculate column1/column2. &nbsp;That's it. &nbsp;I can do that each row at a time, but I cannot do that with the &quot;drag&quot;. &nbsp;I have hundreds out rows to do, is there a way I can do it quicker? &nbsp;<br />
Thanks<br />

</div>
</div>


I have this pivot table, very simple, column 1 and column 2 each hold a count of something.  I need to add a column so that I can calculate column1/column2.  That's it.  I can do that each row at a time, but I cannot do that with the "drag".  I have hundreds out rows to do, is there a way I can do it quicker?  
Thanks


Excel 2007 pivot with custom calculation column apply to each row, how can I drag the cells?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.