Restricting dimensions

[#1]

Hi,

I have a dimension with values 10A, 10B, 10C, 10D,10E. Ot of these I want to display only 10E and 10C. I believe I can do this in the calculated Dimension. Can anyone please help me with the syntax??

[vishsaggi · Accepted solution]

Try this in your dimension

= Pick(Match(Dim, '10E', '10C'), Dim, Dim)

[stabben23]

Or you can use set analysis in your expression

sum({<Dim={'10E','10C'}>}Value)