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
Link to this comment:
All Comments (0)