How to create YTD previous year calculated member?

[Elmiira]

Hi,


I have a promblem with combining two types of calculated members.

Year-to-Date

sum(YTD([Time].[Hierarchy].currentmember),[Measures].[Invoicing])

Previous year as whole

(ParallelPeriod([Time].[Year].[Year],1,[Time].[Year].currentmember),[Measures].[Invoicing])

Could anyone help me by telling where should I put ParallelPeriod function in YTD clause?

Thank you in advance.

Br, Elmiira

 

[MDXer]

Try this

Sum(
    PeriodsToDate(
  		  [Date Dimension].[Fiscal Calendar].[Fiscal Year], 
		  ParallelPeriod(
                		 [Date Dimension].[Fiscal Calendar].[Fiscal Year],1,
                		 [Date Dimension].[Fiscal Calendar].CURRENTMEMBER
				)
            	),
		[Measures].[Your Measure]
)

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[Elmiira]

Thank you Daffy Duck!

It rocks and sings.