Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. PERFORMING PIVOTTABLE CALCULA... > Create a Percentage Summary Calculat...

9.3. Create a Percentage Summary Calculation

You can use Excel's percentage calculations to view data items as a percentage of some other item or of the total in the current row, column, or PivotTable. Percentage calculations are useful data-analysis tools because they enable you to make apples-to-apples comparisons between values. Excel offers seven percentage calculations:

  • % Of. Returns the percentage of each value with respect to a selected base item.

  • % of Row Total. Returns the percentage that each value in a row represents of the total value of the row.

  • % of Column Total. Returns the percentage that each value in a column represents of the total value of the column.

  • % of Grand Total. Returns the percentage that each value represents of the PivotTable grand total.

  • % of Parent Row Total. If you have multiple fields in the row area, this calculation returns the percentage that each value in an inner row represents with respect to the total of the parent item in the outer row.

  • % of Parent Column Total. If you have multiple fields in the column area, this calculation returns the percentage that each value in an inner column represents with respect to the total of the parent item in the outer column.

  • % of Parent Total. If you have multiple fields in the row or column area, this calculation returns the percentage of each value with respect to a selected base field in the outer row or column.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint