Spreadsheet: 852607d1702579499-variance-to-previous-like-pivottable-but-via-formula-variance-to-previous-row-via-dynamic-array
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Desired Result to be Dynamic Array
Fiscal Year/Qtr | Avg. Amount 1 | Avg. Amount 2 | Sum of Amount to the Right | Avg. Amount 3 | Avg. Amount 4 | Avg. Amount 5 | Avg. Amount 6 | Avg. Amount 7 | Avg. Amount 8 | Avg. Amount 9 | Avg. Amount 10 | Avg. Amount 11 | Avg. Amount 12 |  | Fiscal Year/Qtr | Avg. Amount 1 | Avg. Amount 2 | Sum of Amount to the Right | Avg. Amount 3 | Avg. Amount 4 | Avg. Amount 5 | Avg. Amount 6 | Avg. Amount 7 | Avg. Amount 8 | Avg. Amount 9 | Avg. Amount 10 | Avg. Amount 11 | Avg. Amount 12
FY20Q4 | 478118.0196449704 | 189790.3456804734 | 204568.3394729156 | 1761.255325443787 | 19334.29696774192 | 47792.06967741933 | 22433.22309677419 | 25417.05048484849 | 24836.74999999999 | 33792.35177514792 | 1752.174503311257 | -813.1129032258067 | 28262.28054545455 |  | FY20Q4
FY21Q1 | 505103.4180338983 | 194495.0878644068 | 200229.0919920476 | 2293.29179661017 | 20505.95656462588 | 62938.14105442183 | 20690.18431972789 | 26391.76498305085 | 25467.81346938774 | 37366.77098305084 | 2860.968971631206 | 281.9724829931973 | 1432.227366548043 |  | FY21Q1
FY21Q2 | 507929.0514485982 | 186874.0658878505 | 188591.3009899465 | 2219.958457943927 | 17660.67046728973 | 58695.27869158878 | 21733.87794392523 | 26284.62429906541 | 26344.4571495327 | 33575.82700934575 | 1892.018957345972 | 189.7030373831776 | -5.115023474178404 |  | FY21Q2
FY21Q3 | 542234.6686390532 | 216187.189704142 | 241034.0634024314 | 1730.108106508876 | 20237.21918918918 | 67937.2134459459 | 22964.80121621622 | 26140.79265060239 | 27207.77302013425 | 35391.89568047338 | 1989.102424242423 | 698.5774324324321 | 36736.58023668639 |  | FY21Q3
[NAME] | 579098.8658844765 | 233506.9118772563 | 269150.7105962703 | 1751.074007220216 | 20164.56733944956 | 66737.20440366978 | 23094.13743119267 | 24495.06789473685 | 27212.25500000001 | 33873.16472924189 | 1994.863627906979 | 957.344357798165 | 68871.03180505415 |  | [NAME]
FY22Q1 | 677044.6588709678 | 247032.2947580645 | 282927.248896393 | 2532.675161290322 | 25758.11267857141 | 79135.10642857144 | 27965.18089285713 | 32567.16466666667 | 30197.67285714285 | 44007.06306451614 | 2848.961696428571 | 1121.528035714286 | 36793.78341463416 |  | FY22Q1
FY22Q2 | 668301.2538487973 | 227055.0389347079 | 248303.3177409561 | 2911.771099656359 | 23390.79605536329 | 77416.2861245675 | 26815.29301038062 | 34079.0974048443 | 30569.72487889272 | 45057.91307958473 | 2312.493564013841 | 1066.039411764704 | 4683.903111888121 |  | FY22Q2
FY22Q3 | 731120.1492105263 | 242747.060631579 | 258369.5056353361 | 3025.260578947371 | 24820.93542553192 | 83727.32872340427 | 27296.68851063829 | 34525.07968085106 | 30145.05281914894 | 45604.47234042551 | 2476.045319148937 | 1046.126117021277 | 5702.516120218569 |  | FY22Q3
FY22Q4 | 833438.9313970589 | 274232.1427205882 | 301705.5110631358 | 3481.173088235297 | 28215.04187969926 | 94699.26766917294 | 34932.23939849625 | 37497.51548872181 | 34399.49751879701 | 53357.08969924813 | 2410.591954887218 | 1068.774586466165 | 11644.31977941176 |  | FY22Q4
FY23Q1 | 704142.0702380952 | 250386.2930952381 | 264094.7335714285 | 3336.617380952382 | 25253.56023809523 | 82454.4201190476 | 32114.90952380953 | 36104.9875 | 31127.25821428572 | 47392.0538095238 | 2642.283095238095 | 808.7464285714285 | 2859.897261904763 |  | FY23Q1
[NAME] | 594959.7648201439 | 226756.6688489208 | 248512.1154733604 | 3152.030431654672 | 23844.47500000002 | 73629.5252173913 | 27477.69666666665 | 34124.5481884058 | 29002.49268115939 | 44091.14065217391 | 2463.695000000001 | 935.9773913043481 | 9790.534244604323 |  | [NAME]
FY23Q3 | 596039.2547674418 | 219395.1053488372 | 244368.7258720932 | 3305.485755813949 | 24445.79284883724 | 71609.11011627912 | 25524.71226744186 | 33768.17180232564 | 29078.83156976745 | 49205.81465116281 | 2836.359127906977 | 989.2947093023257 | 3605.15302325581 |  | FY23Q3
FY23Q4 | 572778.4212698413 | 212589.8121428571 | 232699.952016098 | 3044.371626984126 | 21921.64575396827 | 65473.76126984127 | 25773.76789682541 | 34733.5792460318 | 28416.94674603173 | 46010.81496031742 | 2250.927611336032 | 633.1325000000008 | 4441.004404761904 |  | FY23Q4
FY24Q1 | 557197.3803550296 | 219469.3330177515 | 249571.1971887875 | 2986.790946745564 | 20888.41216867472 | 66571.73927710838 | 27940.33126506022 | 36538.58584337353 | 30097.98831325303 | 45947.61333333333 | 2373.132727272727 | 568.9266867469876 | 15657.67662721893 |  | FY24Q1
FY24Q2 | 512668.3743778802 | 202018.0081105991 | 224612.0687395504 | 3739.554193548388 | 19233.22622119814 | 59538.97617511523 | 26795.28571428572 | 35745.86059907837 | 28875.94244239635 | 41576.29599078344 | 2063.118693467338 | 1144.959447004609 | 5898.849262672811 |  | FY24Q2