HI,
I am trying to calculate sum of sales in a week/ total sales in a month for entire year based on dynamic formula
<tbody>
Month
FY15
FY15
Fiscal Week
Seasonality
Jul
7/1/2015
$200,836
1
sum of revenue in week 1/ entire month
Jul
7/2/2015
$302,187
1
Jul
7/3/2015
$200,836
1
Jul...