problem with a pivot table

  • Thread starter Thread starter pantelis
  • Start date Start date
P

pantelis

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
 
the pivot table shows the values contained in the field. It is not clear
what you mean by P & N. If you mean you want to show all rows that contain
either P or N, then just select all but F. Otherwise, you will probably
need to create a separate column in the source data that provides the
entries you want to select on.
 
That is what I mean Tom, however, I was looking for a way other than
creating a new column in the database. Is there a way a pivot could do such
a thing.

I gave an example with three groupings under a given field if you have 5 or
10 you cannot do "all but"..

Thanks for your help.
Pantelis
 
individually selecting/unselecting them is about the only way I could see
working with subsets.

Unless you want to write some code to provide a friendlier interface -
however, unselecting items in code is slow
 
Back
Top