Hi,
I wanted to know how to go about referencing singletons?
For example, I have a query called q1.
Inside q1, I have a data items called d1, d2, d3.
And in my report I have singleton s1 and s2
I want to write an expression for d1 so I click on data expression and inside there, I want to write a case when statement like the following:
CASE
WHEN [q1].[d2] = 'X' then s1
WHEN [q1].[d3] = 'Y' then s2
END
Is this possible?
Thanks in advance.