Using Wildcard filtering Dimension values in pivot table

[ingoniclas]

I want to have fields to be displayed in a pivot table only if certain contitions are met. For example, I only want [field] to be displayed if a user selects a value that contains 'K10'. Therefore, I went to Chart Properties -> Dimensions -> Enable Conditional, and I typed in:

[field] = 'K10*'

But this does not work. It works w/o he asterik, but I want to filter for any vaule containing K10. Does * not work as a wildcard here?

[ingoniclas]

Mark, many thanks! This works well for me!

[ingoniclas]

There is one question left - what if I want this to work for additional values say K10* AND U20*? I tried the following, but it didn't work:

GetFieldSelections([field]) like 'K10*' OR *U20*'

GetFieldSelections([field]) like 'K10*' AND *U20*'

Any ideas?

[swuehl]

=GetFieldSelections([field]) like 'K10*' AND GetFieldSelections([field]) like '*U20*'

[ingoniclas]

I figured that out by myself in the meantime, but many thanks anyway Stefan.

[Anonymous]

Thanks Gysbert..