MTD in straight table

[Anonymous]

Hi, QVers,

After did some search and test, I am stucked to use MTD in a pivot/straight table with Week as a dimension.

What I want is a straight, and later a pivot table as below:

Week,       WeekEnd,  sum(A), sum(B), sum(C),  MTD sum(C)

2015-18, 2015-05-03,            ,              ,            ,  sum(Date={">='2015-05-01'<='2015-05-03'"}C )

2015-19, 2015-05-10,            ,              ,            ,  sum(Date={">='2015-05-01'<='2015-05-10'" }C)

2015-20, 2015-05-17,            ,              ,            ,  sum(Date={">='2015-05-01'<='2015-05-17'"}C )

I tried, seems because "Week" is an dimension, sum({1}C) =sum(C), so the set analysis Date range dose not work.

May I know how to calculate the MTC in this case?

Thanks very much

[Gysbert_Wassenaar]

Perhaps this document helps: Calculating rolling n-period totals, averages or other aggregations