View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pantelis pantelis is offline
external usenet poster
 
Posts: 27
Default problem with a pivot table

Hi all,

Got a bit of a problem with a pivot table. In a certain field say "class" I
have the following categories "F", "P" & "N".

Now, when I have "class" in the pivot table as a selection, the drop down
indicates the above three categories, ("F", "P", "N") which I can use to
filter data.

However, I would like it not to see ("F" or "P" or "N") as a selection for
the data to be filtered but ("F" or "P & N").

I would appreciat anyones input.

Hope I got the problem accross.

Thanks
Pantelis