Hello Cognoise,
I have a data item expression that looks like this:
substring(
roleValue('_memberCaption';[General Ledger - Income Statement].[Result division].[Result division].[Result division]);1;1)
which gives me the first letter of all the Result divisions (e.g A, B, C, D).
What I want to do, is to filter this expression, only showing Result division "A" and "D"
One solution I came up with was to put this expression in detail filters:
[Result division] starts with 'A' or [Result division] starts with 'D'
The question is then: Is this possible to achieve this using other filter techniques like slicer or filter function instead ? Since I prefer to not use Detail filters when working with OLAP source. (The report loading time became much longer).
Best regards,
Oscar