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

problem with a pivot table
 

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.

--
Regards,
Tom Ogilvy

"pantelis" wrote in message
...
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

problem with a pivot table
 

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




"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

"pantelis" wrote in message
...
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

problem with a pivot table
 

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
--
Regards,
Tom Ogilvy

"pantelis" wrote in message
...
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




"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

"pantelis" wrote in message
...
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