How to Generate Multiple Reports from One Pivot Table
Most people who use Excel Pivot Tables know how to change the design of the reporty. However, in my experience, most people do not know how to create multiple reports - each on a separate worksheet - from a single Pivot Table.
You can do this with just a few mouse clicks if - you have at least one field in the Report Filter section of your Pivot Table. If you use Excel 2003, this section is the Page area of your Pivot Table.
In this lesson, I also demonstrate how to create a Calculated Field for your Pivot Table.
Please visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my video lessons.
Sincerely,
Danny Rocks
The Company Rocks