August 24, 2005 at 1:52 am
Hi,
I'd need to implement calculated members such as 'The last three months' and the same one year ago. The first one is OK but I can't implement the other.
Sum(PeriodsToDate([Time].[Month], [Time].CurrentMember), [Measures].
[Sales Grossval])
gives the sum in current month
Sum(LastPeriods(3, [Time].CurrentMember), [Measures].[Sales Grossval])
gives the sum during the previous three months
BUT how to get the same values behind one year to appear at the same
row of measures i.e.
$ Month $ Last 3 months $ Last 3 months prev year 2004 Jan 100 100 2004 Feb 200 300 2004 Mar 100 400 … 2004 Nov 50 200 2004 Dec 60 210 2005 Jan 50 160 100 2005 Feb 300 410 300 2005 Mar 100 450 400
(hand written example data)
Regards, VilleAugust 24, 2005 at 5:33 pm
You should be able to do this using the ParallelPeriod function. Something like the following should work
SUM(LastPeriods(3, ParallelPeriod(Year, 1, [Time].CurrentMember), [Measures].[Sales Grossval])
Steve.
August 24, 2005 at 11:47 pm
Jep,
that's it! Thank you
V
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply