Spreadsheet: 726527d1617284572-pivot-table-create-calculated-column-on-running-total-calculated-field-scot07-
Sheet: Sheet2

 | Column Labels
 | A |  |  | B |  |  | C |  |  | D |  |  | Total Sum of Sales | Total Sum of Customers | Total Average of SalesPerCustomer
Row Labels | Sum of Sales | Sum of Customers | Average of SalesPerCustomer | Sum of Sales | Sum of Customers | Average of SalesPerCustomer | Sum of Sales | Sum of Customers | Average of SalesPerCustomer | Sum of Sales | Sum of Customers | Average of SalesPerCustomer
2021-01-01 00:00:00 | 388 | 4 | 97 | 1167 | 1 | 1167 | 1105 | 13 | 85 | 620 | 18 | 34.44444444444444 | 3280 | 36 | 91.11111111111111
2021-01-02 00:00:00 | 1398 | 12 | 116.5 | 1619 | 18 | 89.94444444444444 | 2167 | 26 | 83.34615384615384 | 2573 | 24 | 107.2083333333333 | 7757 | 80 | 96.9625
2021-01-03 00:00:00 | 2955 | 13 | 227.3076923076923 | 2155 | 27 | 79.81481481481481 | 2667 | 46 | 57.97826086956522 | 4097 | 34 | 120.5 | 11874 | 120 | 98.95
2021-01-04 00:00:00 | 4234 | 28 | 151.2142857142857 | 2891 | 44 | 65.70454545454545 | 4394 | 64 | 68.65625 | 5947 | 36 | 165.1944444444445 | 17466 | 172 | 101.546511627907
2021-01-05 00:00:00 | 4778 | 30 | 159.2666666666667 | 3648 | 48 | 76 | 5044 | 69 | 73.10144927536231 | 6125 | 56 | 109.375 | 19595 | 203 | 96.52709359605912
2021-01-06 00:00:00 | 5945 | 46 | 129.2391304347826 | 4890 | 63 | 77.61904761904762 | 5576 | 88 | 63.36363636363637 | 7003 | 74 | 94.63513513513513 | 23414 | 271 | 86.39852398523985
2021-01-07 00:00:00 | 7261 | 51 | 142.3725490196078 | 6487 | 82 | 79.10975609756098 | 6100 | 105 | 58.09523809523809 | 8036 | 79 | 101.7215189873418 | 27884 | 317 | 87.96214511041009
2021-01-08 00:00:00 | 8238 | 63 | 130.7619047619048 | 8532 | 87 | 98.06896551724138 | 7348 | 114 | 64.45614035087719 | 8505 | 85 | 100.0588235294118 | 32623 | 349 | 93.4756446991404
2021-01-09 00:00:00 | 10565 | 82 | 128.8414634146341 | 9658 | 103 | 93.76699029126213 | 7941 | 129 | 61.55813953488372 | 9802 | 87 | 112.6666666666667 | 37966 | 401 | 94.6783042394015
2021-01-10 00:00:00 | 12508 | 90 | 138.9777777777778 | 11842 | 119 | 99.5126050420168 | 8870 | 149 | 59.53020134228188 | 12001 | 99 | 121.2222222222222 | 45221 | 457 | 98.95185995623632
2021-01-11 00:00:00 | 12831 | 104 | 123.375 | 12663 | 129 | 98.16279069767442 | 9867 | 167 | 59.08383233532934 | 14195 | 107 | 132.6635514018692 | 49556 | 507 | 97.74358974358974
2021-01-12 00:00:00 | 14723 | 112 | 131.4553571428571 | 14602 | 138 | 105.8115942028985 | 11401 | 178 | 64.0505617977528 | 15691 | 112 | 140.0982142857143 | 56417 | 540 | 104.4759259259259
2021-01-13 00:00:00 | 16815 | 128 | 131.3671875 | 16759 | 141 | 118.8581560283688 | 12076 | 187 | 64.57754010695187 | 16735 | 125 | 133.88 | 62385 | 581 | 107.3752151462995
2021-01-14 00:00:00 | 16984 | 145 | 117.1310344827586 | 18351 | 145 | 126.5586206896552 | 13151 | 189 | 69.58201058201058 | 18115 | 131 | 138.2824427480916 | 66601 | 610 | 109.1819672131148
2021-01-15 00:00:00 | 17825 | 155 | 115 | 20688 | 157 | 131.7707006369427 | 14172 | 197 | 71.93908629441624 | 18882 | 133 | 141.9699248120301 | 71567 | 642 | 111.4750778816199
2021-01-16 00:00:00 | 18060 | 165 | 109.4545454545455 | 22762 | 158 | 144.0632911392405 | 15536 | 210 | 73.98095238095237 | 21379 | 136 | 157.1985294117647 | 77737 | 669 | 116.1988041853513
2021-01-17 00:00:00 | 19867 | 169 | 117.5562130177515 | 24755 | 159 | 155.6918238993711 | 17375 | 229 | 75.87336244541484 | 22711 | 143 | 158.8181818181818 | 84708 | 700 | 121.0114285714286
2021-01-18 00:00:00 | 20957 | 189 | 110.8835978835979 | 24899 | 173 | 143.9248554913295 | 19437 | 248 | 78.375 | 23358 | 149 | 156.7651006711409 | 88651 | 759 | 116.7997364953887
2021-01-19 00:00:00 | 21656 | 190 | 113.978947368421 | 25383 | 189 | 134.3015873015873 | 20826 | 252 | 82.64285714285714 | 24255 | 150 | 161.7 | 92120 | 781 | 117.9513444302177
2021-01-20 00:00:00 | 23607 | 198 | 119.2272727272727 | 25897 | 193 | 134.1813471502591 | 21315 | 261 | 81.66666666666667 | 26506 | 166 | 159.6746987951807 | 97325 | 818 | 118.979217603912
2021-01-21 00:00:00 | 25108 | 211 | 118.9952606635071 | 27156 | 196 | 138.5510204081633 | 22753 | 277 | 82.14079422382672 | 27278 | 168 | 162.3690476190476 | 102295 | 852 | 120.0645539906103
2021-01-22 00:00:00 | 26750 | 230 | 116.304347826087 | 29415 | 212 | 138.75 | 23634 | 285 | 82.92631578947369 | 28506 | 186 | 153.258064516129 | 108305 | 913 | 118.6254107338445
2021-01-23 00:00:00 | 28300 | 238 | 118.9075630252101 | 31315 | 216 | 144.9768518518518 | 23806 | 300 | 79.35333333333334 | 28858 | 201 | 143.5721393034826 | 112279 | 955 | 117.5696335078534
2021-01-24 00:00:00 | 30643 | 248 | 123.5604838709677 | 33528 | 233 | 143.8969957081545 | 25673 | 301 | 85.29235880398672 | 30007 | 214 | 140.2196261682243 | 119851 | 996 | 120.3323293172691
2021-01-25 00:00:00 | 32234 | 262 | 123.030534351145 | 34002 | 248 | 137.1048387096774 | 26253 | 302 | 86.93046357615894 | 31536 | 220 | 143.3454545454545 | 124025 | 1032 | 120.1792635658915
2021-01-26 00:00:00 | 34481 | 272 | 126.7683823529412 | 34434 | 258 | 133.4651162790698 | 26887 | 306 | 87.86601307189542 | 32538 | 240 | 135.575 | 128340 | 1076 | 119.275092936803
2021-01-27 00:00:00 | 36846 | 275 | 133.9854545454546 | 35940 | 275 | 130.6909090909091 | 28773 | 321 | 89.6355140186916 | 34867 | 251 | 138.9123505976096 | 136426 | 1122 | 121.5918003565062
2021-01-28 00:00:00 | 37365 | 276 | 135.3804347826087 | 37303 | 292 | 127.75 | 30564 | 333 | 91.78378378378379 | 36315 | 252 | 144.1071428571429 | 141547 | 1153 | 122.7640936686904
2021-01-29 00:00:00 | 37642 | 281 | 133.9572953736655 | 39425 | 311 | 126.7684887459807 | 31169 | 344 | 90.60755813953489 | 37346 | 257 | 145.3151750972763 | 145582 | 1193 | 122.0301760268231
2021-01-30 00:00:00 | 39629 | 283 | 140.0318021201414 | 41774 | 324 | 128.9320987654321 | 31293 | 360 | 86.925 | 39539 | 270 | 146.4407407407408 | 152235 | 1237 | 123.0679062247373
2021-01-31 00:00:00 | 41986 | 294 | 142.8095238095238 | 42153 | 328 | 128.515243902439 | 32753 | 370 | 88.52162162162162 | 39738 | 271 | 146.6346863468635 | 156630 | 1263 | 124.0142517814727
2021-02-01 00:00:00 | 43771 | 305 | 143.5114754098361 | 44225 | 347 | 127.4495677233429 | 34968 | 374 | 93.49732620320856 | 40762 | 288 | 141.5347222222222 | 163726 | 1314 | 124.6012176560122
2021-02-02 00:00:00 | 46073 | 311 | 148.144694533762 | 46379 | 366 | 126.7185792349727 | 35691 | 382 | 93.43193717277487 | 42672 | 292 | 146.1369863013699 | 170815 | 1351 | 126.4359733530718
2021-02-03 00:00:00 | 47123 | 312 | 151.0352564102564 | 48205 | 378 | 127.526455026455 | 37236 | 386 | 96.46632124352331 | 44995 | 311 | 144.6784565916399 | 177559 | 1387 | 128.0165825522711
2021-02-04 00:00:00 | 48110 | 314 | 153.2165605095541 | 48979 | 385 | 127.2181818181818 | 37860 | 405 | 93.48148148148148 | 46820 | 319 | 146.7711598746081 | 181769 | 1423 | 127.7364722417428
2021-02-05 00:00:00 | 50340 | 331 | 152.0845921450151 | 51000 | 405 | 125.9259259259259 | 40082 | 421 | 95.20665083135393 | 47990 | 331 | 144.9848942598187 | 189412 | 1488 | 127.2930107526882
2021-02-06 00:00:00 | 51110 | 334 | 153.0239520958084 | 51502 | 418 | 123.2105263157895 | 41560 | 424 | 98.01886792452831 | 49622 | 345 | 143.831884057971 | 193794 | 1521 | 127.4122287968442
2021-02-07 00:00:00 | 52227 | 352 | 148.3721590909091 | 53481 | 435 | 122.9448275862069 | 42147 | 441 | 95.57142857142857 | 51697 | 355 | 145.6253521126761 | 199552 | 1583 | 126.0593809222994
2021-02-08 00:00:00 | 53890 | 353 | 152.6628895184136 | 54130 | 446 | 121.3677130044843 | 43322 | 448 | 96.70089285714286 | 52740 | 364 | 144.8901098901099 | 204082 | 1611 | 126.6803227808814
2021-02-09 00:00:00 | 56390 | 372 | 151.5860215053764 | 56429 | 461 | 122.4056399132321 | 44303 | 466 | 95.07081545064378 | 54986 | 384 | 143.1927083333333 | 212108 | 1683 | 126.0297088532383
2021-02-10 00:00:00 | 56712 | 389 | 145.7892030848329 | 58450 | 465 | 125.6989247311828 | 45604 | 484 | 94.22314049586777 | 56594 | 396 | 142.9141414141414 | 217360 | 1734 | 125.3517877739331
2021-02-11 00:00:00 | 57524 | 407 | 141.3366093366093 | 59271 | 478 | 123.9979079497908 | 46304 | 500 | 92.608 | 58609 | 402 | 145.7935323383085 | 221708 | 1787 | 124.0671516508114
2021-02-12 00:00:00 | 59506 | 419 | 142.0190930787589 | 60488 | 489 | 123.6973415132924 | 47508 | 513 | 92.60818713450293 | 60052 | 409 | 146.8264058679707 | 227554 | 1830 | 124.3464480874317
Grand Total |  |  | 136.6089793210218 |  |  | 126.0978303747535 |  |  | 86.29209533607681 |  |  | 143.0914648212226 |  |  | 120.4823493686262