If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Calculation using mdx

Started by tven77, 20 Jan 2014 02:25:10 PM

Previous topic - Next topic

tven77

Hello guys,
Can anyone help me create a calculation using MDX? I'm a bit new to DMR and mdx but slowly gaining grounds.

Here is the scenario:

Date             Item      Measure

Sept-13        A           10
                 B           5
                 C          1
                 D          2
                 E

Oct-13         A          8
                B          5
                C         1
                D         2
                E

Nov-13        A         0
               B         5
               C         3
               D         2
               E

I want to insert a calculated E under item D with the following for formula :

E = [(A+B+C+D) - A(of next month]

like for example for Sept-13 calculation

E(for Sept-13) = [A+B+C+D (of sept-13) - A (of Oct-13)]

Hope you can help me  on this. Thanks!