Variant of YTD: Generating a table of YTX where X is from a list of dates ... How?

[#1]

Hi,

I have a fact table of sales with dates that I would like to be able to use to generate a corresponding table showing the YTD values for each date.  This should be interactive and correspond to whatever possible selected dimension combination -- and be independent of the date selected. 

Q1: What should a set analysis expression look like for computing the year-to-date cummulative YTX value, where X is a static end date on the table?

Q2: Would the expression need to be different if dealing with weekly data vs monthly data?

Thanking in advance for your help.

As a specific example, I would like to generate a YTX table that looks like below (pivot table with a static KeepDate dimension defining the cummulative end date of X across?).  The Fact table contains dimensions Product, Region, and Date with the fact data being Sales.

Product	Region	Aug 2011	Sep 2011	Oct 2011	Nov 2011	Dec 2011	Jan 2012	Feb 2012	Mar 2012
A	North	400	450	500	550	600	70	140	210
B	North	48	54	60	66	72	7	14	21
C	North	72	81	90	99	108	10	20	30
A	West	800	900	1000	1100	1200	120	240	360

   I tried the following expressions but get a "-" value back.  Please help me understand where my problem in the expression is?  Thanks!

=

Sum({$
<Date={"<=$(=KeepDate)"},
Year = Year(Date),
Quarter = ,
Month =
>
}
Sales)

[Anonymous]

Hi,

   in expressino your adding year,that one is not required,if adding year means data will be filter based on year also.

Regards

[Anonymous]

Hi,

   in expressino your adding year,that one is not required,if adding year means data will be filter based on year also.

Regards

[Anonymous]

Hi,

   in expressino your adding year,that one is not required,if adding year means data will be filter based on year also.

Regards

[Anonymous]

Hi,

   in expressino your adding year,that one is not required,if adding year means data will be filter based on year also.

Regards