Straight Table

[evansabres]

Hello -

I am attempting to create a straight table that references a field named promoCDE  from which there are several types of promoCDE's that I'd like to focus. I want my table to specifically only show the promoCDE's of

'ADULT'

'2FAMPK'

'HOLHAT'

'KIDDAY'

I'd assume I'd add a calculated dimension, but I cannot seem to get the syntax correct.

[Anonymous]

Could you share the your calculated dimension with the syntax you suspect as dodgy ?

Although Set Analysis in your expression could be better.

[sunny_talwar · Accepted solution]

You can use calculated dimension, or set analysis.

1) Calculated Dimension

If(Match(promoCDE, 'ADULT', '2FAMPK', 'HOLHAT', 'KIDDAY'), promoCDE)

2) Set Analysis

{<promoCDE = {'ADULT', '2FAMPK', 'HOLHAT', 'KIDDAY'}>}

[Chanty4u]

=Pick(promoCDE, '

'ADULT'

'2FAMPK'

'HOLHAT'

'KIDDAY')

[evansabres]

The set analysis would only be used for an expression correct?

[Anonymous]

Yup - Correct.