Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2005-02-03 : 23:08:09
|
| Hi,I want to create a calculated member with the following logic:Depending on the selected level in my time dimension, this calculated member should give me the total sales of the past 6 months (using a field called NetSales).So if I am at the year level of say 2005This calculated member should give the sales of June - Dec 2004If I am on March 2005This calculated member should give the sales of Sep 04 - Feb 05I hope my explanation is clear. Will appreciate your help. Thanks |
|
|
|
|
|
MDX Help needed