Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cumulative Measure by Year

Status
Not open for further replies.
anumala28

anumala28

Programmer
Jun 28, 2002
87
US
Hi,

How do i get create cumulative measure by year.
I have measure empcount measure, using this measure i need to cumulative measure. Can please give any suggession.
Ex:

Year Count Cumulative Count
2005 1 1
2005 2 3
2005 3 6
2005 4 10
2006 5 5
2006 6 11
2006 7 18
2006 8 26

Thanks





Please help me out how to do it using MDX.

Thanks,

 
Status
Not open for further replies.

Similar threads

Rolaper
  • Locked
  • Question
MDX Calc measure to accomdate Smi-Additive and delta SCD at the same time?
Replies
0
Views
202
Rolaper
Rolaper
nodoubtom
  • Locked
  • Question
SSAS 2008 - Duplicated calculated measure values
Replies
0
Views
178
nodoubtom
nodoubtom
Rubicks
  • Locked
  • Question
Time Dimension With Multiple Sets for Different Fiscal Year Definition 1
Replies
1
Views
136
RiverGuy
RiverGuy
eo
  • Locked
  • Question
MDX Calc measure to accomdate Smi-Additive and delta at the same time? 1
Replies
5
Views
199
eo
eo
simonB2010
  • Locked
  • Question
Setting Many MeasureExpressions
Replies
0
Views
130
simonB2010
simonB2010

Part and Inventory Search

Sponsor

Back
Top