Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
If(Question = 'A1a', Question)
Thanks- and how do i exclude all results not equal to A1a?
If(Question = 'A1a', Question) - This only returns A1a values and excludes all others
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.