View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stix_1998
 
Posts: n/a
Default Pivot Table Question

Hello,

I have created a pivot table in Excel 2002 that is using a list of data from
another tab in Excel 2002. Within the page filters, I have several filters
in which I would like to be able to select multiple items at one time but
can't figure out how to do it. For example, one of my page filters is
'Category'. Currently, I can only select ONE of the following: 'All',
'Category 1', 'Category 2', 'Category 3', etc. I would like to be able to
select multiple items at once such as 'Category 1' and 'Category 2' at the
same time. Any help would be greatly appreciated.