Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
Try this in your dimension
= Pick(Match(Dim, '10E', '10C'), Dim, Dim)
Or you can use set analysis in your expression
sum({<Dim={'10E','10C'}>}Value)