mtd calculation by using week range

[Anonymous]

hi folks,

how  can i calculate month to date in pivot table.

by using 1st week total,2nd week total,3rd week total

means add the data of week range to get sum of 30 days

plz find the attached excel(sample target)

[v_iyyappan · Accepted solution]

hi,

Use the Dimension Month in Chart.

=SUM({<

     Year=,    

     Month=,    

     DateFieldNum=

     {'>=$(=(num(WeekStart(DateField))))<=$(=(num(WeekEnd(DateField))))'}>}Sales)

     Where

     DateFieldNum= Num(DateField)

Regards,

Iyyappan