Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2010 - Pivot Table - new Worksheets
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel 2010 - Pivot Table - new Worksheets
Resolved · Low Priority · Version 2010
Reply Mon 25 Jul 2011, 12:21Delegate Holly said...
Holly has attended:
Excel Advanced course
Excel 2010 - Pivot Table - new Worksheets
Martin showed us a really useful way to "Spin off" data contained in the Pivot Table (Report Filter) into separate new worksheets within the main workbook. I can't find this in the reference manual and unfortunately I didn't note down the details. Would someone be able to remind me how to do this, please?
For upcoming training course dates see: Pricing & availability
RE: Excel 2010 - Pivot Table - new Worksheets
Hello Holly,
Thank you for your question regarding Pivot Reporting.
Once you have created a Pivot table and have a field in the Report Filter area e.g. Gender, and you wish to see pivots for the Men on one sheet and Women on another sheet.
From the PivotTable Tools Ribbon, Select the Options sub-ribbon (not design). On the far left of this ribbon bar will be a button called Options. Click on the drop menu on the right of this button. From the drop down select Show Report Filter pages. From the dialog box that appears select the field you want filtered to seperate pages. Click OK and it will insert pages based on that field.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
|