Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table with a measure that calculates the average number of boxes shipped per day by each warehouse. I'd like to get a sum of those averages by warehouse so I can then do a percentage of total calculation. The current expression to get average of boxes per day is:
Avg(Aggr(Sum({$<RecordType={"LOAD"}>} UnitsLoaded),Date))
I've tried modifying that expression in order to get the total for all warehouses but haven't been able to get any variations to work as I expect.
Avg(Aggr(Sum({$<RecordType={"LOAD"},Warehouse=>} UnitsLoaded),Date))
Avg(Aggr(Sum({1<RecordType={"LOAD"}>} UnitsLoaded),Date))
Sum(Aggr(Avg({$<RecordType={"LOAD"}>} UnitsLoaded),Date))
etc.
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
PFWarehouse | Avg Boxes Loaded Per Day | Total | % |
HUR | 125,098 | 928,151 | 13.48% |
SAL | 139,650 | 928,151 | 15.05% |
SBF | 131,870 | 928,151 | 14.21% |
SSS | 134,232 | 928,151 | 14.46% |
YBF | 148,953 | 928,151 | 16.05% |
YSS | 123,223 | 928,151 | 13.28% |
YUM | 125,125 | 928,151 | 13.48% |
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?