Spreadsheet: 732426d1620939586-i-need-to-add-a-specific-calculated-field-within-a-pivot-table-pivot-table-calculated-item-daws-
Sheet: datadump

Location | Financial Year | Month | Cash value | Count of cartons
Stafford | 2020 | January | 14781.92 | 3109
[NAME] | 2020 | January | 18195.59 | 4396
Telford | 2020 | January | 67267.5 | 206476
Stoke | 2020 | January | 4375.57 | 3069
Peterborough | 2020 | January | 752.52 | 812
Hartlepool | 2020 | January | 10206.37 | 809
[NAME] | 2020 | January | 258.57 | 413
[NAME] | 2020 | January | 97.75 | 16
Exeter | 2020 | January | 21.73 | 10
Solihull | 2020 | January | 2216.84 | 3132
Stafford | 2020 | February | 11300.27 | 2730
[NAME] | 2020 | February | 5669.6 | 1264
Telford | 2020 | February | 43030.05 | 156521
Stoke | 2020 | February | 3423.72 | 1906
Peterborough | 2020 | February | 276.3 | 436
Hartlepool | 2020 | February | 7467.3 | 569
[NAME] | 2020 | February | 124.59 | 286
[NAME] | 2020 | February | 71 | 16
Exeter | 2020 | February | 59.49 | 13
Solihull | 2020 | February | 225.16 | 341
Stafford | 2020 | March | 12174.18 | 2151
[NAME] | 2020 | March | 9467.98 | 2102
Telford | 2020 | March | 78037.63 | 187423
Stoke | 2020 | March | 3413.07 | 1499
Peterborough | 2020 | March | 309.12 | 185
Hartlepool | 2020 | March | 5710.66 | 431
[NAME] | 2020 | March | 200.13 | 333
[NAME] | 2020 | March | 88.5 | 12
Exeter | 2020 | March | 80.36 | 12
Stafford | 2020 | April | 12398.35 | 2116
[NAME] | 2020 | April | 887.61 | 341
Telford | 2020 | April | 83587.15 | 174024
Stoke | 2020 | April | 2320.08 | 1314
Peterborough | 2020 | April | 159.85 | 150
Hartlepool | 2020 | April | 8217.74 | 521
[NAME] | 2020 | April | 110.74 | 428
[NAME] | 2020 | April | 50.29 | 8
Exeter | 2020 | April | 89.79 | 16
Stafford | 2020 | May | 14524.25 | 2622
[NAME] | 2020 | May | 707.33 | 403
Telford | 2020 | May | 104749.88 | 263342
Stoke | 2020 | May | 1532.32 | 1597
Peterborough | 2020 | May | 492.79 | 302
Hartlepool | 2020 | May | 15868.82 | 749
[NAME] | 2020 | May | -27.50999999999999 | 657
[NAME] | 2020 | May | 57.65 | 16
Exeter | 2020 | May | 51.66 | 12
Stafford | 2020 | June | 16241.06 | 3136
[NAME] | 2020 | June | 6556.18 | 1899
Telford | 2020 | June | 79769.63 | 292164
Stoke | 2020 | June | 1962.48 | 2221
Peterborough | 2020 | June | 689.25 | 376
Hartlepool | 2020 | June | 15861.71 | 668
[NAME] | 2020 | June | 290.95 | 791
[NAME] | 2020 | June | 56.5 | 11
Exeter | 2020 | June | 181.89 | 35
Stafford | 2020 | July | 15785.53 | 2781
[NAME] | 2020 | July | 14631.38 | 2963
Bedford | 2020 | July | 136.53 | 1073
Telford | 2020 | July | 97861.92 | 280109
Stoke | 2020 | July | 3243.58 | 2615
Peterborough | 2020 | July | 1157.93 | 315
Hartlepool | 2020 | July | 13047.86 | 413
[NAME] | 2020 | July | 365.79 | 728
[NAME] | 2020 | July | 41.7 | 27
Exeter | 2020 | July | 179.51 | 25
Stafford | 2020 | August | 11390.45 | 2484
[NAME] | 2020 | August | 6528.83 | 1303
Bedford | 2020 | August | 112 | 1102
Telford | 2020 | August | 105571.44 | 219033
Canterbury | 2020 | August | 712.97 | 146
Luton | 2020 | August | 2626.21 | 555
Stoke | 2020 | August | 2357.32 | 1747
Peterborough | 2020 | August | 59.04 | 251
Hartlepool | 2020 | August | 5014.7 | 345
[NAME] | 2020 | August | 573.48 | 550
[NAME] | 2020 | August | 9.15 | 24
Exeter | 2020 | August | 39.11 | 4
Stafford | 2020 | September | 24452.45 | 2655
[NAME] | 2020 | September | 6886.42 | 1284
Bedford | 2020 | September | 2969.78 | 3490
Telford | 2020 | September | 111128.87 | 197708
Canterbury | 2020 | September | 10993.8 | 663
Luton | 2020 | September | 5817.03 | 730
Stoke | 2020 | September | 1856.41 | 2224
Peterborough | 2020 | September | 910.83 | 340
Hartlepool | 2020 | September | 12949.99 | 448
[NAME] | 2020 | September | 419.71 | 476
[NAME] | 2020 | September | 0.2 | 44
Exeter | 2020 | September | 17.22 | 2
Stafford | 2020 | October | 16580.19 | 2965
[NAME] | 2020 | October | 7211.77 | 1186
Bedford | 2020 | October | 5522.21 | 4365
Telford | 2020 | October | 68621.91 | 211415
Canterbury | 2020 | October | 11947.37 | 1125
Luton | 2020 | October | 5004.57 | 837
Stoke | 2020 | October | 4672.78 | 2719
Peterborough | 2020 | October | 1207.81 | 575
Hartlepool | 2020 | October | 13034.09 | 350
[NAME] | 2020 | October | 493.92 | 525
[NAME] | 2020 | October | 207.58 | 49
Exeter | 2020 | October | 14.79 | 2
Stafford | 2020 | November | 17353.2 | 3471
[NAME] | 2020 | November | 14607.98 | 4362
Bedford | 2020 | November | 7994.25 | 6928
Telford | 2020 | November | 99592.21 | 271372
Canterbury | 2020 | November | 21283.78 | 1093
Luton | 2020 | November | 6248.68 | 1022
Stoke | 2020 | November | 8050.36 | 2318
Peterborough | 2020 | November | 1497.22 | 935
Hartlepool | 2020 | November | 18283.24 | 386
[NAME] | 2020 | November | 573 | 568
[NAME] | 2020 | November | 290.02 | 46
Exeter | 2020 | November | 31.6 | 5
Stafford | 2020 | December | 12916.44 | 2590
[NAME] | 2020 | December | 33350.58 | 6220
Bedford | 2020 | December | 13975.67 | 11006
Telford | 2020 | December | 157770.7 | 250542
Canterbury | 2020 | December | 3597.86 | 313
Luton | 2020 | December | 6497.71 | 876
Stoke | 2020 | December | 4362.84 | 2895
Peterborough | 2020 | December | 1429.77 | 1140
Hartlepool | 2020 | December | 24829.07 | 593
[NAME] | 2020 | December | 914.84 | 652
[NAME] | 2020 | December | 199.08 | 34
Exeter | 2020 | December | 18.79 | 4
Stafford | 2021 | January | 2895.11 | 4041
[NAME] | 2021 | January | 52109.89 | 13113
Bedford | 2021 | January | 6583.03 | 7976
Telford | 2021 | January | 85682.18 | 212073
Canterbury | 2021 | January | 2537.76 | 251
Luton | 2021 | January | 0 | 818
Stoke | 2021 | January | 3543.28 | 3109
Peterborough | 2021 | January | 824.34 | 1020
Hartlepool | 2021 | January | 4620.24 | 242
[NAME] | 2021 | January | 844.45 | 580
[NAME] | 2021 | January | 0 | 13
[NAME] | 2021 | January | 10325 | 7124
Exeter | 2021 | January | 8.55 | 1
Stafford | 2021 | February | 19615.29 | 3280
[NAME] | 2021 | February | 55682.18 | 18207
Bedford | 2021 | February | 8288.06 | 6388
Telford | 2021 | February | 52109.89 | 13130
Canterbury | 2021 | February | 1121.45 | 217
Luton | 2021 | February | 13119.15 | 900
Stoke | 2021 | February | 4203.24 | 1873
Peterborough | 2021 | February | 1557.93 | 800
[NAME] | 2021 | February | 590.29 | 149
Hartlepool | 2021 | February | 2937.83 | 311
[NAME] | 2021 | February | 558.6 | 387
[NAME] | 2021 | February | 109.4 | 132
[NAME] | 2021 | February | 12956 | 8775
Swindon | 2021 | February | 0 | 408
Stafford | 2021 | March | 19070.01 | 2987
[NAME] | 2021 | March | 45665 | 18467
Bedford | 2021 | March | 12547.92 | 9384
Telford | 2021 | March | 9098.93 | 18022
Canterbury | 2021 | March | 6128.06 | 523
Luton | 2021 | March | 5975.08 | 1050
Stoke | 2021 | March | 4801.31 | 3050
Peterborough | 2021 | March | 2170.2 | 799
[NAME] | 2021 | March | 1874.91 | 540
Hartlepool | 2021 | March | 1221.77 | 177
[NAME] | 2021 | March | 629.35 | 611
[NAME] | 2021 | March | 11.2 | 57
[NAME] | 2021 | March | 16054 | 9623
Exeter | 2021 | March | 0.1 | 2
Swindon | 2021 | March | 0 | 2880