Calculating A Weighted Average In a Pivot Table

Originally Posted by Stormin'

Use a calculated column to do
SUM(DIs) / SUM(Days)
to get an average of DIs per day (or swap the calculation to get days per DI)


Note that you cannot calculate this line by line in the source data, it has to be aggregate data.

Thanks for the reply, but I don't believe this is what I'm looking for. You're offering a straight average; I'm trying to get a weighted average, one which accounts for each SHIPPER's significance to the average before averaging for the whole network.