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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to create YTD previous year calculated member?
Thank you :) Daffy Duck! It rocks and sings.- Elmiira
- Post #3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
How to create YTD previous year calculated member?
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...- Elmiira
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
