Pivot Table data output on multiple sheets

S

Sean

I would like to know if there is a way to automatically get Excel to
create the same pivot table on several sheets with each sheet showing
a selection of the data.
For Example
On one sheet the pivot table which relates to the male
and
Another sheet the pivot table relating to the females
 
D

Debra Dalgleish

You can use the Show Pages command to create multiple Pivot Tables:

Move the Gender field to the Page area
Select a cell in the Pivot table
 
Top