I want to add a 16 week rolling AVG in a pivot table.

I have a spreadsheet used for tracking Quality issues.

Currently it uses a pivot table to break down each product into various categories. I

A pivot table is used to calculate how many incidents of various categories arise for each product.

I would then like to get a 16 week rolling AVG in the pivot table.

if you can provide some data, can try some solution. try to post data in attachment

I'm attaching some data.

Thanks, I posted an example copy

Originally Posted by murarihyd

if you can provide some data, can try some solution. try to post data in attachment