Dec 11, 2013 at 6:09 AM
Edited Dec 11, 2013 at 6:11 AM
I am working with SQL Server 2012 SSAS.
I build my Cube everything is working very good.
I want to make a new “Calculations”
Create Member CurrentCube.Measures.[X]
It is not calculating right ?
Month Country | Region | Market | SKU | Value | X
January Egypt | Alexandria | Croissant | MoltoWC | 261570.00 | 728390.00
January Egypt | Alexandria | Croissant | MoltoSC | 201500.00 | 728390.00
January Egypt | Alexandria | Croissant | BrunchTC | 2550.00 | 728390.00
January Egypt | Alexandria | Croissant | BrunchTP | 262770.00 | 728390.00
X = the Sum of Column [Value]
Month = same month of the current Row
AND Region = same Region of the current Row
AND Market = same Market of the current Row