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 |
|
qutesanju
Posting Yak Master
193 Posts |
 Posted - 2010-09-06 : 05:12:39
|
| Hi Experts,I need urgent help on this issueI have a formula 'Sum(LastPEriods(13, CLosingPeriod([Rolling Date].[Month], [Rolling Date].CurrentMember)), [Measures].[Waste Costs])'which calculates rolling costs for last 13 monthse.g today current month + last 12 months,but when i drill down to hierarchy level 8 it shows me few records of year 2006 also,i think this shuld not be case,coz formula should show me records till july 2009 (assuming go back 13 months from current date)can you please guide me are there any corrrections in this formula or if i m going to level 8 -drill down then it will include costs for 2006 also?I'm unable to make any firm conclusion on this |
|
|
qutesanju
Posting Yak Master
193 Posts |
Posted - 2010-09-06 : 08:48:44
|
| Please help |
 |
|
|
qutesanju
Posting Yak Master
193 Posts |
Posted - 2010-09-08 : 02:30:06
|
| guys please check this |
|
|
|
|
|
|
Finding rolling costs for 13 months