How to Work with Numeric Values in Excel Pivot Tables
One of my clients asked for my help with an Excel Pivot Table. She needed to work with a field that contains Numeric Values - The Employee ID Field - rather than with fields that contain the Text Labels for Employee Names.
Beginning with Excel 2007, if you check a field that contains Numeric Values, it gets automatically placed into the Values Area for the Pivot Table and the Sum Function is used to Subtotal these values.
This is where my client got "twisted into knots."
Watch as I walk her step-by-step through the solution to this problem.
I invite you to visit my secure online shopping website - http://shop.thecompanyrocks.com - to sample the many video training resources that I offer you.
Danny Rocks
The Company Rocks