Pivot Table Calculated field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pivot table with columns for No's, Yes's and Grand Total. I would like to calculate the % of Yes's by
dividing the Yes's by the Grand total. Can someone give me an easy explanation of how to do that or a source? I have tried every thing I can think of and the directions I have found have not helped.... Thanks, Ann
 
To calculate total percent Yes, you could use the GETPIVOTDATA function
in a formula outside the pivot table. For example:

=GETPIVOTDATA("Region",$A$5,"Valid","Yes")/GETPIVOTDATA("Region",$A$5)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I perform extended calculations in a Pivot Table in Excel 2 4
Referencing a pivot tables Grand Totals Column 1
Pivot table grand total location 1
pivot table excel 2
calculate grand total 2
Average of Subtotals in Pivot Table 0
Totaling blank cells in Pivot Tables 8
Pivot Table Calculates the Difference in Grand Total 2

Back
Top