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.”
Link to this post!
[…] Show Percentage of Total Calculations in a Pivot Table […]