I have a measure [Measures].[Estimated Value]
and i have hierarchy [EstimatedCloseDate].[Calendar Time] with normal attributes like Year<-Quarter<-Month-<Date.
I am trying to figure out two name sets. One requirement is I want:
sum of previous estimated value,Current Quarter (Q4 2010), Q1 2011, Q2 2011, Q3 20100, sum of future estimated value
Second requirement is:
Last year estimated value, Q1 2010, Q2 2010, Q3 2010, Q4 2010 --I mean all quarters of current year.
I would really appreciate the help guys.
View Complete Post