View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mjc
 
Posts: n/a
Default Pivot Table help - select pages

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!