This Foodmart query might be helpful:
with member measures.[LastYearSales] as '(ancestor(time.currentmember
,[Year]).Prevmember, [unit sales])'
select
{[Measures].[Unit Sales] ,[LastYearSales] } on columns,
descendants( [1998],month,self_and_before) on rows
from Sales
HTH,
Brian
www.geocities.com/brianaltmann/olap.html
"christy" wrote:
Quote:
I am using the ParallelPeriod function to get the sales for last year same
period. How can I get the last year total (1/1 to 12/31) no matter where I am
in the time dimension. If I am on 10/21/2004, I'd like to see the total for
the whole year of 2003. |