Pivot Table filters?

[ShaneDevenshire]

Hi Folks,

In the PC versions of Excel the row and column fields have filter dropdowns
which make it easy to pick as many items as you want to display. These
features are not available even on the 2004 MAC version. Why is this useful
feature absent and what does one use in its stead?

TIA,
Shane

 

[CyberTaz]

Hi Shane -

I'm not the development expert here by a long shot, but I believe it's one
of many features implemented on the PC via ActiveX Controls. ActiveX has
never been implemented on any version of Mac OS.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Geoff Lilley]

I think Bob's right about that being an ActiveX control, but I'm no
expert, either. The best workarounds I could foresee would be one of
these two:

1) <inelegant hack>Right-click (or control-click) on on the field,
choose "Field Settings," and click on the item(s) you want to hide. To
hide multiple items, hold down your Command (Apple) key.</inelegant
hack>
2) If there's a column you could add to the underlying data source
that would help you differentiate, that would be more elegant. For
example, if I had state names in the row field, and I wanted to show
only California, Nevada, Washington, Oregon, Arizona, and Idaho, then
what I might do is create a field called "Region." I would then set
the "Region" for those states to "Pacific Northwest." Then, I could
take states like New York, New Jersey, Delaware, Massachussets, and
label those "Eastern Seabord." (You get the idea ). Then, add a
page field for "Region," and filter for the Region. Not great, I
admit, but I know what you're talking about, and that's the best
workaround I've found to date.

HTH
Cheers
Geoff