Pivot Table help - select pages

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

Guest

I work with pivot tables all the time. But one thing that seems to be
inconsistent is the following:

When I select a field to be a pivot table's "page" (usually a column that
describes a year), it will sometimes allow me to check off multiple years I
want to look at, sometimes I can only view one at a time (one option of which
is "all").

How do I switch back and forth, particularly switch to the checkboxes so I
can view, for instance, 1999, 2000, 2001 and 2002, but not 1998 and 2003?

Thanks!
 
Hi

Yes, it's annoying isn't it!!
You can drag the Year from Page to Row, make your required selection of
Years, then drag the field back to Page again.
The dropdown box will display "Multiple Items" rather than "All", but it
will include just the years you selected whilst as a Row field.
 

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

Pivot Table ? 1
Question on the occupied field of the pivot table in excel spreadsheet 0
How do I refresh a PivotTable and remove outdated page field entr. 2
Pivot table filter list - listing irrelevant subcategorys 1
Pivot Tables 1
Excel Pivot Tables 1
Pivot Table - Changes 5
Different ways to build Pivot table 1

Back
Top