Show Percentage of Calculations in Pivot Tables

Most people are content to let a Pivot Table Sum, Average, or Count their Values Fields. But what if you want to see individual Products as a percentage of all products sold in a Region – this is a standard request for Excel. And … it is easy to perform this calculation in a Pivot Table. Let me show you how to do this.

Follow this link to subscribe to the Danny Rocks “Tips and Timesavers” Podcast at the iTunes Store.

Learn how to “Quickly Create Pivot Tables and Charts in Excel.”

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
How to Show Percentage of Calculations in Pivot Tables Play Now | Play in Popup | Download (125)

rss Subscribe to our RSS Feed

This entry was posted on Wednesday, June 23rd, 2010 at 7:36 AM and is filed under Excel Training, Pivot Tables, Podcast Tips & Timesavers. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

«
»

One Response to “Show Percentage of Calculations in Pivot Tables”

  1. My Most Viewed and Downloaded Videos for Excel PowerPoint | Danny Rocks Tips and Timesavers Says:
    December 14th, 2010 at 5:06 PM

    [...] Show Percentage of Total Calculations in a Pivot Table [...]

Leave a Reply

Powered by WishList Member - Membership Site Software