How to add "Show Value As" calculations to your Excel Pivot Table

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
1,851
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jun 24, 2010

In my experience, I have found that most people are content to let their Pivot Table perform Sum, Average and Count functions. And then, they go outside of the Pivot Table to add in a formula that references "static cells" in the Pivot Table.

In this video, I demonstrate how to use the "Show Values As" tab in your Pivot Table Field Properites to perform "% of row" and "% of coumn" calculations.


I invite you to visit my website - www.thecompanyrocks.com - to veiw all of my videos and to shop for my DVD, "The 50 Best Tips for Excel 2007."

Danny Rocks

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (0)

Sign In or Sign Up now to post a comment!
Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more