This content has been marked as final. Show 4 replies
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|
I tried the following expressions but get a "-" value back. Please help me understand where my problem in the expression is? Thanks!
Year = Year(Date),
Quarter = ,