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

Category:

Education

Tags:

• Excel Pivot Table Reports
• Report Filter
• Show Report Pages
• Work with Copy of Pivot Table
• Software Tutorial
• How-to
• Microsoft Excel
• Training
• Pivot Tables
• Management
• Technology
• Data
• Office
• Business
• Computer Software

[jennilhenry]

This wasn't what I was looking for but is a great time saving feature I will use in the future - thank you!

[DannyRocksExcels]

@jennilhenry

I am glad that you learned something new from this tutorial.

Give me more information about what you are really looking for and perhaps I cen send you in the right direction.

Danny Rocks

The Company Rocks

[thanhdavis2001]

hi, thank you for your instruction. I followed the video but I always have this message "A PivotTable report cannot overlap another PivotTable report" when I tried to move the data up and down in field list. Pls help. Thank you in advance.

[DannyRocksExcels]

@thanhdavis2001

Thanks for contacting me!

In this case, you have copied a Pivot Table and then Pasted the Copy onto the same worksheet - as I demonstrate in this tutorial.

KEY POINT: If you are going to change the dimensions of any of these multiple Pivot Tables, ensure that you have placed sufficient space between the Copies of the Pivot Tables - preferably, BEFORE you paste the compy.

Let me know if this helps you.

Danny Rocks

The Company Rocks

[thanhdavis2001]

Hi Danny,

Thank you for your help very much, it's very helpful....I followed your iinstruction and it works now....do you high level training for Pivot table? Tks.

[DannyRocksExcels]

@thanhdavis2001

Great! I am pleased that this is now working for you.

Re: Pivot Table Training - I have published a 90 minute video tutorial for Pivot Tables. I sell this - at my online store (send me a message and I will give you the link) as either a downloadable product or in DVD-ROM format. Versions available for Excel 2003, Excel 2007 and Excel 2010.

Danny Rocks

The Company Rocks

[jennilhenry]

@DannyRocksExcels (Pt 3) Sorry it's hard to explain, but basically the totals for devices are listed at the top then the users would be below. Since it's a long report they want the devices at the beginning with their total for the month. I have looked up how to do two totals/reports in one then found out about the 'column' in the 'Row Labels' and can't figure out how he got them there

[jennilhenry]

@DannyRocksExcels (Pt 2) Basically it's two reports in one. The only thing I can figure out is they were somehow able to put the Column listing on the report and filter for Device and User creating two reports in one. But I am not sure how to get the column name as a filter in the report. 

[jennilhenry]

@DannyRocksExcels Thanks for the reply. I have a report I am trying to mimic but I can't find the owner. The report shows the total number of pagers, cells, etc that were ordered for the company. Currently my report has by device type then by who ordered it. Somehow the previous person that did it got the total devices to show up at the top with a total then another report within the pivot table showing the users that ordered them.

[novaztec]

@DannyRocksExcels lol thas my mom. srry, she was trying to learn the stuff. for a min i thought i was hacked.