Need to show rolling 14 days of sales in a chart where the time dimension could be day, week, or month. So if the chart is showing week, I need to sum the last 14 days of sales for each weekending date on the chart. If by mont, then I need to sum the last 14 days of sales for each weekending date on the chart. Pleasea advise.
