Getting the Week-to-date data from available Daily and Weekly Sales from the pivot table.

[saraf]

I have the weekly sales and daily sales in the pivot table and I need to populate the Week-to-Date data.

I am creating a dynamic formula to capture the data. The formula I have used is in form of =SUM(A1:A2)

=SUM(GETPIVOTDATA("[Measures].[Sales (Net)]",WeekDay!$A$9,"[Media]","[Media].[Group].&[Mail]","[Call Date]","[Call Date].[Call Day].&["&TEXT(X12-WEEKDAY(X12)+1, "YYYY-MM-DD")&"]"):GETPIVOTDATA("[Measures].[Contacts (Net)]",WeekDay!$A$9,"[Media]","[Media].[Group].&[Mail]","[Call Date]","[Call Date].[Call Day].&["&TEXT(IF(WEEKDAY(X12)=7,7,7-WEEKDAY(X12))+X12, "YYYY-MM-DD")&"]"))

Where X12 is the date for which I need the data for that whole week until that date.

Please let me know if you have any other idea which pulls WTD or pls check where I am goin wrong.

Thank you,

Thank you