Filter dimension by difference
Posted: Mon Mar 04, 2013 9:29 pm
Hi all,
I have a dimension composed by the following elements:
A(2012)
B(2012)
C
D(2012)
E
F14
Create a subset with elements that end with(2012) is easy: I use FILTERBYPATTERN and a string with jolly character *(2012)*
But I would like create a subset composed by
C
E
F14
i.e. elements that DON'T end with (2012).
How can i perform this?
Thanks in advace
Regards
I have a dimension composed by the following elements:
A(2012)
B(2012)
C
D(2012)
E
F14
Create a subset with elements that end with(2012) is easy: I use FILTERBYPATTERN and a string with jolly character *(2012)*
But I would like create a subset composed by
C
E
F14
i.e. elements that DON'T end with (2012).
How can i perform this?
Thanks in advace
Regards