I have this table generated with MDX.
http://i62.tinypic.com/2m5xeg0.jpg
I need to create a calculated dimension (or a measure) called "this year" with 2 values:
YES: if currentmember YEAR includes value 2015 and
NO: if member YEAR does not include 2015 for every CLIENT ID
http://i57.tinypic.com/2h508yx.jpg
The MDX code is:
SELECT NON EMPTY {[Measures].[QUANTITY]} ON COLUMNS, NON EMPTY CrossJoin({CLIENT ID].[CLIENT ID].Members, {[YEAR].[YEAR].Members}) ON ROWS FROM [MyCube]