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?
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
