when fiscal weeks, Quarter,sales_amount are there how can we get average of sales-amount with respect to number of fiscal weeks updated in that quarter
example : Q1=FW1 to FW13
Q1=sum(sales_amount)/FW count = 331/13=25.461.
consider Q2 and Q3 as above
now coming to Q4 as this quarter is in progress we had only count of FW as 11
based on next week this count gets increment
we need the above calculation similar to this dynamically.