Home > Archive > MS SQL Server Reporting Services > October 2005 > Can't get the YTD to work at all please help me









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Can't get the YTD to work at all please help me
Tomas

2005-10-28, 8:24 pm

Current YTD : Works
sum(PeriodsToDate([Time].[Year],[Time].Currentmember), [Measures].[Revenue])

Previous YTD: Does not
([Measures].[Actual Revenue],ClosingPeri
od([Time].[Year],Ancestor
([Time].CurrentMember,Year).PrevMember))

This YTD does not work either.
([Measures].[Actual Revenue], ParallelPeriod([Time].[Year],1))

Remember that I am trying to keep summing as you go down Time.
When I select Feb 2005, it should return Jan + Feb 2005
Please help me
Tomas


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com