dimensions in chart

[Bubskim]

Hi all,

Please help.

I need to add a dimension to my chart. Basically I have the used dimension of DL Name - this comes from the column name in my excel. I need to exclude certain DL's (distributions list) form displaying. How do I write an expression for that?

I am not the best in if or wild match I really need to exclude and or suppress specific DL's

[lockematthewp · Accepted solution]

You can do:

=if ([DL Name] <> 'whatever', [DL Name])

or if there are multiple:

=if (wildmatch([DL Name], 'whatever', 'orThis', 'orThat') = 0, [DL Name])

[Marcos_rv]

but do you have an excel with the excluded? you could use an applimaps and mapping to build a flag, "if you must exclude it".

Regards!!!