Pivot Table Column Item List only specific String
 

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

Pivot Table Column Item List only specific String
 

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