1.1.3 Step 3 – Calculate Average sales for last 4 weeks (AST)
Calculate the average total sales (SALES_REGULAR+SALES_MARKDOWN) from the DIMENSION_DAILY_STATS table for the 4 weeks for the target sale date’s day of week + days of sales target (e.g. last 4 Saturdays , 2 days of sales = last four segments of Saturday and Sunday). This value will represent the average sales to target (AST).