Combining dates (workweeks) into a rolling sum?

[Kirkebbs]

I have created a report that displays on the top row ww1, ww2, ww3, ww4. However what is requested, is a rolling 4 week aggregation, so that at the close of business in ww5, the data contained in the pivot table will be for WW2 through ww5, aggregated. Thus, the top row will now only be one column instead of 4 columns, and the data underneath it will be the average of the rolling 4 weeks. How can this be done? Thanks Kirk

 

[nimmy99]

In the pivot option you can hide the remaining three columns.