Excel 2010 - Pivot Table - new Worksheets | Excel forum

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