Hi All
I am facing issue in handing the set analysis with reference to time , I need the volume change if sales on quarterly basis , semester basis and annual basis and I have to consider everything from max date of that company
For ex company ABC has max or recent date as 07/22/2016 same as other company have different max date
1. need to sum of the sales on quarterly basis I.e from
2. need to sum of the sales on the yearly basis that
sum of the sales of previous year
volume change in the sales in current quarter and last quarter i.e from (sept-december_sales ) - (june-august_sales)
volume change in the sales in current year and last year i.e from (current_year_sales ) - (last_year_sales)
i know it is very generic questions but I am struk in handling the dates , I tried many thing to get that but not getting the appriopiate answer I have to play basically on month basis means but on weekly data I have filter like 1 week , 4 week , 13 week and 26 week and 52 week and comparision like current 13 week compare to previous 13 week
please file the excel file for reference