Dear users,

My colleague and I are desperate here... does anybody can help???

We are importing data from a web-based source, which is afterwards
processed by a pivot table for reporting issues (normal pivot wizard
for dummies, i.e. me). Though, there are too many items in one column
(selection criteria). I would like to have those criteria directly
filtered by the pivot table. There are some items I do not need, some
of them I do need them. The only criteria is, if there is a string
"rtcor" appearing in it.

For example

BSMLI -- not needed, should not be shown in the results
DRTCOR33343 -- needed, all results liked to this criteria should be
shown
JDSRTCORND -- needed, all results should be shown

I have no idea how to work with "formulas" in the Pivot Table Wizard.
Furthermore, I do not want to have a VBA filter in between.

Thanks a lot for your inputs!!! Would help us a lot and make it easier
to distribute it.

Regards,

Rico

Not sure if this will work for you...

I'd add another column to the raw data table.

Put in a formula that evaluates to true/false or any kind of category indicator
to filter on.

Then use that field as a page field.

You can choose the category you want to see pretty easily.

ricowyder wrote:

Dear users,

My colleague and I are desperate here... does anybody can help???

We are importing data from a web-based source, which is afterwards
processed by a pivot table for reporting issues (normal pivot wizard
for dummies, i.e. me). Though, there are too many items in one column
(selection criteria). I would like to have those criteria directly
filtered by the pivot table. There are some items I do not need, some
of them I do need them. The only criteria is, if there is a string
"rtcor" appearing in it.

For example

BSMLI -- not needed, should not be shown in the results
DRTCOR33343 -- needed, all results liked to this criteria should be
shown
JDSRTCORND -- needed, all results should be shown

I have no idea how to work with "formulas" in the Pivot Table Wizard.
Furthermore, I do not want to have a VBA filter in between.

Thanks a lot for your inputs!!! Would help us a lot and make it easier
to distribute it.

Regards,

Rico

--

Dave Peterson