Excel 2007 PivotTable Question

[Dale Howard [MVP]]

Excel friends --

I am using Microsoft Office Excel 2007 and created a PivotTable that
includes a field in the Filter Fields drop area. When I click the pick list
button for the field in the Filter Fields drop area, the pick list menu
includes a "Select Multiple Items" option. After selecting this option, I
am able to select multiple items on which to filter using that field. This
option is very cool; however, I have run into a problem. 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!

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

 

[Dale Howard [MVP]]

Excel friends --

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?

--
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]

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 ....

....

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?

 

[Dale Howard [MVP]]

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"