Calculated dimension help - simple

[#1]

hi,

I can't remember the syntax (the god awful syntax...)

Can someone help me ?

I want to make a calc. dimension which does the following

Question = 'A1a'

If i were writing in SQL, what I'm after would look like this:

SELECT

     Question

WHERE

     Question = 'A1a'

Could anyone help me get my syntax correcT?

[swuehl]

If(Question = 'A1a', Question)

[#3]

Thanks- and how do i exclude all results not equal to A1a?

[#4]

If(Question = 'A1a', Question) - This only returns A1a values and excludes all others

[swuehl · Accepted solution]

Not sure if I understand, above calculated expression should only show the value A1a.

Ah, you may need to enable the option 'Suppress when value is NULL' on dimension tab.