Re-bucket weekly sales data and calculate descriptive statistics
If the week ID is given as you state, calculate a bucket variable $w_x=int(weekID/x)$.  Then use a SQL statement to summarize the volume to levels of $w_x$.