How do i create multiple pivot tables with one field automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

about pivot table 1
Group in Multiple Pivot table 1
Formula fields in Pivot Tables? 1
Multiple listboxes to update pivot table? 2
Different ways to build Pivot table 1
How do I add extra data to a pivot table? 3
Summing Formula fields in Pivot Tables? 3
Formula fields in Pivot table reports? 2

Back
Top