Page field in pivot tables

G

Guest

I have created a pivot table report and I have chosen to have a page field.
Instead of looking at one result at a time I know there is a way to get each
page of the report shown on its own worksheet. I have done this in the past
but cannot remember how to do it or find instructions on how to do it. Can
someone help?
 
D

Debra Dalgleish

Select a cell in the pivot table
I have created a pivot table report and I have chosen to have a page field.
Instead of looking at one result at a time I know there is a way to get each
page of the report shown on its own worksheet. I have done this in the past
but cannot remember how to do it or find instructions on how to do it. Can
someone help?
 
G

Guest

Thanks Debra, for some reason I never use that toolbar. It seems like that
functionality should be a right click on the item in the page field. Oh
well. Thanks again for pointing me in the right direction.
 
D

Debra Dalgleish

You're welcome. If it's something you do frequently, you could add the
Show Pages button to the Pivot Table toolbar, so it's easier to access.
 

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

Top