Hey Guys,

This one has me stumped. Here's my problem:

I have a pivot table that shows work orders & associated data from a SQL query. I have the pivot sorted by desending work order number. Of all the work orders that show up from the query, I only want to average the last 12 work order numbers (i.e. a running 12 work order average). "Top 10" doesn't seem to fit this scenario & I can't seem to find a way to filter these other than manually with a slicer. I'd like to have it automated a little more than that though. Anyone have any ideas that might point me in the right direction?

Any & all ideas welcome; a way to do this on the pivot table, a different query script, VBA, anything at all...