Hi,
I have data with machine speeds per hour (number of feeds/hours) in worked out from per day that is then put into a pivot table with a Timeline filter in it.
The result is an average of averages speed when multiple days are selected on the timeline.
What I really need is not an Average of Averages, but the actual result, i.e. I select multiple days, then show me the (sum of feeds/total hours). Pivot only seems to be able to do an average?
I have data with machine speeds per hour (number of feeds/hours) in worked out from per day that is then put into a pivot table with a Timeline filter in it.
The result is an average of averages speed when multiple days are selected on the timeline.
What I really need is not an Average of Averages, but the actual result, i.e. I select multiple days, then show me the (sum of feeds/total hours). Pivot only seems to be able to do an average?
