Attachment has been updated.

Logically that seems like it should work; unfortunately, it gives a blank result.

Don't see the attachment

I guess it's still loading?  If it doesn't show up in a few minutes I'll upload again.

Updated attachment should be there now.

Hi,

Are you expecting following information?

Hi Vijay,

No, the totals you have look like the totals for the whole year.  I'm trying to get a total of all of the daily averages for each warehouse.  Thanks.

Hi Sunny.  Have you had a chance to look at the new attachment I loaded?  Thank you.

.

Hi,

Is your requirement as follows

Formula For Avg Boxes Loaded Per Day is Avg(Aggr(Sum({$<RecordType={"LOAD"}>} UnitsLoaded),Date))

Total is sum of each of those individual values for warehouse

That is the behavior I'm looking for.  Are you able to replicate that behavior in a pivot table?