How do i create multiple pivot tables with one field automatically

I'm trying to get a sheet for every single element of a field in a pivot table.
I know this is possible by double clicking in the field once it's located at
the top of the pivot table. But i haven't been able to do it now and i was
wondering if there's a certain option i should flag or unflagged.

Thank you.

If you have at least one field in the page area, select a cell in the
pivot table, and on the pivot table toolbar, choose PivotTable>Show Pages.

Leonardo wrote:
> I'm trying to get a sheet for every single element of a field in a pivot table.
> I know this is possible by double clicking in the field once it's located at
> the top of the pivot table. But i haven't been able to do it now and i was
> wondering if there's a certain option i should flag or unflagged.
>
> Thank you.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html