Does your data only have those four fields or is there something like Employee ID where you could do a Count Distinct? That would work no matter how you rolled it up (though it is different than average).
If you really want an average, I think it would be possible. Do you happen to have some sample data (even dummy data) you could share?
This actually seemed to have worked!