Spreadsheet: 75168d1275680493-pivot-table-calculations-sample
Sheet: Sheet2

 | Values
Row Labels | Count of Last Years Price PD | Sum of Last Years Price PD2 | Average of Last Years Price PD3 | Count of This Years Price Pd | Sum of This Years Price Pd2 | Average of This Years Price Pd3 | Sum of Field1 | Unit %
AL0 | 32 | 46549.55714285714 | 1454.673660714286 | 22 | 30350 | 1379.545454545455 | 0.6519933134241879
AZ0 | 9 | 8120.540000000001 | 902.2822222222223 | 5 | 4975 | 995 | 0.6126439867299465
CA1 | 10 | 18080.83252747252 | 1808.083252747253 | 7 | 11765 | 1680.714285714286 | 0.6506890643516513
CO0 | 144 | 222365.7828571429 | 1544.206825396825 | 119 | 178943.78 | 1503.729243697479 | 0.8047271378751695
GA0 | 34 | 64295.32457875457 | 1891.038958198664 | 19 | 40354 | 2123.894736842105 | 0.6276350615598941
IA0 | 103 | 200312.0966666666 | 1944.777637540453 | 93 | 189755 | 2040.376344086022 | 0.9472967591955548
ID0 | 46 | 73630.89 | 1600.67152173913 | 38 | 63002.92 | 1657.971578947368 | 0.8556588138483726
IN0 | 16 | 15861.41 | 991.338125 | 13 | 12658.54 | 973.7338461538462 | 0.7980715459722686
KY0 | 2 | 1340.65 | 670.325 | 1 | 957 | 957 | 0.7138328422779995
LA0 | 13 | 19147.5473992674 | 1472.888261482108 | 7 | 13825 | 1975 | 0.7220245868423314
MN0 | 26 | 26811.39 | 1031.207307692308 | 18 | 17635.9 | 979.7722222222224 | 0.6577764151728054
MO0 | 13 | 14355.73 | 1104.286923076923 | 5 | 5579 | 1115.8 | 0.3886253085005082
MS0 | 7 | 8623.95 | 1231.992857142857 | 4 | 6023 | 1505.75 | 0.6984038636587642
MT0 | 7 | 3955.52 | 565.0742857142857 | 4 | 2380 | 595 | 0.6016908017150716
NC0 | 43 | 63967.38039215687 | 1487.61349749202 | 29 | 44647.5 | 1539.568965517241 | 0.6979729313016279
OH1 | 22 | 35546.38 | 1615.744545454546 | 15 | 25265 | 1684.333333333333 | 0.7107615459014391
OH2 | 1 | 1164.96 | 1164.96 |  |  |  | 0
OK0 | 23 | 28853.92666666667 | 1254.518550724638 | 14 | 18240 | 1302.857142857143 | 0.6321496623567584
OR0 | 17 | 27161.57 | 1597.739411764706 | 10 | 16265.75 | 1626.575 | 0.5988516127749611
TN0 | 27 | 28936.02 | 1071.704444444445 | 20 | 19140 | 957 | 0.6614593161049792
TX0 | 23 | 88868.34 | 3863.840869565217 | 21 | 84831.56 | 4039.598095238095 | 0.9545757240430056
TX1 | 20 | 31362.30769230769 | 1568.115384615385 | 12 | 20160 | 1680 | 0.642809840327684
TX2 | 75 | 136148.4615384615 | 1815.312820512821 | 57 | 104545 | 1834.122807017544 | 0.7678750007062427
TX3 | 70 | 124612.4203296703 | 1780.177433281005 | 54 | 98036.5 | 1815.490740740741 | 0.786731368676076
TX4 | 6 | 3970 | 661.6666666666666 | 6 | 2970 | 495 | 0.7481108312342569
TX5 | 6 | 5969.62 | 994.9366666666666 | 4 | 3980 | 995 | 0.6667091037620485
TX6 | 10 | 13818.33 | 1381.833 | 3 | 5040 | 1680 | 0.3647329308244918
TXS | 21 | 85021.62 | 4048.648571428571 | 16 | 64610 | 4038.125 | 0.7599243580632785
UT0 | 22 | 33406.71 | 1518.486818181818 | 14 | 22178.04 | 1584.145714285714 | 0.6638798013931932
VA1 | 3 | 2242.857142857143 | 747.6190476190477 | 1 | 795 | 795 | 0.3544585987261146
WA0 | 5 | 4541.2 | 908.24 | 3 | 2490 | 830 | 0.5483132211750198
WI0 | 46 | 104404.97 | 2269.673260869565 | 39 | 88574.16 | 2271.132307692308 | 0.8483711072375195
WV0 | 6 | 7539.755714285714 | 1256.625952380952 | 5 | 7275 | 1455 | 0.9648853723756492
WY0 | 4 | 2780 | 695 | 3 | 1985 | 661.6666666666666 | 0.7140287769784173
Grand Total | 912 | 1553768.050648567 | 1703.69303799185 | 681 | 1209232.65 | 1775.672026431718 | 0.7782581508837482