Hello
I have a pivot table of waiting times and looking at the below for 2017, the grand total is wrong. When I highlight Oct, Nov & Dec totals, the average of selected cells (in the bottom status bar) says 3:29:19
Can anyone shed any light on why they're different?
<tbody>
</tbody>
I have a pivot table of waiting times and looking at the below for 2017, the grand total is wrong. When I highlight Oct, Nov & Dec totals, the average of selected cells (in the bottom status bar) says 3:29:19
Can anyone shed any light on why they're different?
Average Dwell Time | |
Audit Date | Total |
Oct | 05:04:22 |
Nov | 02:41:03 |
Dec | 02:42:32 |
Grand Total | 02:42:09 |
<tbody>
</tbody>
Last edited: