Hi all,
I've got a mdx statement as follows:
WITH
member [TST] AS SUM([Date KER].[Year Name].CURRENTMEMBER, [Measures].[Turnover])
SELECT NON EMPTY {
[TST],
[Measures].[Turnover]
} ON COLUMNS,
NON EMPTY {
nonempty((
[Date KER].[Year Name].[Year Name].MEMBERS,
[Top customers and others]
), [Measures].[Turnover] )
} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS FROM (
SELECT ( StrToSet('{[Date KER].[Year Name].&[2011]}') )
ON COLUMNS FROM [KER Cube])
the Result looks like this:
Year Customer TST Turnover
2011 400025 50,551,979.00 50,551,979.00
2011 804080 49,625,351.78 49,625,351.78
2011 804390 49,501,712.11 49,501,712.11
2011 806990 35,546,586.41 35,546,586.41
2011 803130 22,830,782.93 22,830,782.93
The calculated Member [TST] should SUM ALL Values by Year (2011). In this case that would mean the same amount should stay in each row.
In the future version the years will be flexible (more than one year, etc.).
Is there any possibility to achieve that?
Thanks!
Fabian
