hi! Is it possible make a custom metric for average per week?

Ideally I would like to be able to calculate APW for any specified time frame, and have the option to exclude weeks when an item marked down.

For example, if I wanted to know the APW of the Elliot in Black for weeks 1-25, it would kick out 52 as the APW.