Sunday, July 30, 2017

How to Show Values as Percentages of in Excel Pivot Tables



I participate in several LinkedIn Sharing Groups. In one of the groups, the question was raised: How do I show percentage of Total Sales by Category and also percentage of Cumulative Sales (running total)?

In this video tutorial I demonstrate how to perform these calculations first in Excel 2010 – the best way – and also in Excel 2007 – with a “work-around.”

I invite you to visit my online shopping website – http://shop.thecompanyrocks.com – to view all of my video tutorials and to sample the many resources that I offer you.

Danny Rocks
The Company Rocks


Also see: Help With Percentages

The post How to Show Values as Percentages of in Excel Pivot Tables appeared first on Verandi.org.



source http://verandi.org/how-to-show-values-as-percentages-of-in-excel-pivot-tables/

No comments:

Post a Comment