Harlan --

Thanks for the reply. I wasn't whining; I was just asking for confirmation.

When I say And, I am referring to the Boolean function. The pick list in
the Filter Fields drop area allows me to select multiple items from the list
for that one particular field. When I pick multiple items from the list,
Excel does an Or filter rather than an And filter, in the Boolean sense, of
course. I suspect there is no way to change this behavior. I was just
hoping someone would give me a definitive Yes or No as to whether it can be
done.

I apprecate your help.

--
Dale A. Howard [MVP]
VP of Educational Services
msProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"


"Harlan Grove" wrote in message
...
"Dale Howard [MVP]" <dale(dot)howard(at)msprojecexperts(dot)com wrote...
As a Microsoft Project MVP, a question that generates no replies usually
means that what the user wants to do in Microsoft Project simply cannot be
done. I would be grateful if an Excel MVP would simply tell me that what
I want to do is not possible. Any takers?

Whine, whine.

In the Excel newsgroups nearly all questions are answered. Those that
don't usually don't because it doesn't look like they need to be. When
someone posts with [MVP] in their 'From' tag, most readers would assume
that posting is a response, so an answer, to a question, and so move on to
other questions. You may want to consider dropping the [MVP] when posting
to newsgroups other than those for MS Project.

"Dale Howard [MVP]" <dale(dot)howard(at)msprojecexperts(dot)com wrote in
...
When I select this option and then select multiple items on the pick
list,
I assumed that Excel would do an "And" filter with these multiple
selected
items, but discovered that it does an "Or" filter instead. Does anyone
know of a way to change this functionality, so that selecting multiple
items forces an "And" filter and not an "Or" filter? Thanks in advance
for your help! :)
...

Multiple selections apply to each field separately/individually, they're
simple matches against what's already in the table that generates the
pivot table, and they mean AND in the 'in addition to' sense. For example,
selecting 1st and 2nd quarters from a Fiscal_Period field which means pull
data from both the 1st and 2nd quarters, not pull records that are from
the 1st and simultaneously from the 2nd quarters (an empty set).

Or do you mean this for multiple fields in combination?