I've got a workbook which contains the following data points:
- A list of roughly 8 shippers
- A list of roughly 800 destinations facilities
- A count of distinct pallet IDs shipped from each shipper to each destination by fiscal week
All I'm trying to do is find the average weekly pallet count by year and destination facility which, in my head, should be a single number per fiscal year, but I'm getting the weird break out as seen below. Am I using AVERAGE() incorrectly?
Please sign in to leave a comment.