Loading...

How to Generate Multiple Reports from One Pivot Table

205,752 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Mar 11, 2011

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

  • Category

  • License

    • Standard YouTube License

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...