Spreadsheet: 114052d1309920952-method-to-get-a-formula-from-another-cell-or-sum-every-nth-cell-ptexample
Sheet: Sheet1

Region | Date | Gross$ | Net$ | Shrink$
North |  |  |  |  |  | <<Fake Data |  | VV Pivot Table - Filter by Region - Collapse or expand days - Running Totals example.
East
South
West |  |  |  |  |  |  |  | Region | North
North
East |  |  |  |  |  |  |  | Row Labels | Sum of Gross$ | Sum of Net$ | Sum of Shrink$ | Run Total of Gross
South |  |  |  |  |  |  |  | 2011 | 297900 | 238404 | 29526
West |  |  |  |  |  |  |  | Jan | 57896 | 45898 | 5373
North |  |  |  |  |  |  |  | 2-Jan | 1862 | 1584 | 215 | 1862
East |  |  |  |  |  |  |  | 3-Jan | 1834 | 1487 | 343 | 3696
South |  |  |  |  |  |  |  | 4-Jan | 4414 | 3423 | 265 | 8110
West |  |  |  |  |  |  |  | 5-Jan | 551 | 389 | 0 | 8661
North |  |  |  |  |  |  |  | 6-Jan | 2083 | 1572 | 378 | 10744
East |  |  |  |  |  |  |  | 7-Jan | 2595 | 2243 | 208 | 13339
South |  |  |  |  |  |  |  | 9-Jan | 726 | 653 | 8 | 14065
West |  |  |  |  |  |  |  | 10-Jan | 1227 | 901 | 173 | 15292
North |  |  |  |  |  |  |  | 12-Jan | 2554 | 2059 | 269 | 17846
East |  |  |  |  |  |  |  | 13-Jan | 2644 | 2012 | 199 | 20490
South |  |  |  |  |  |  |  | 14-Jan | 3781 | 3131 | 427 | 24271
West |  |  |  |  |  |  |  | 15-Jan | 670 | 566 | 98 | 24941
North |  |  |  |  |  |  |  | 19-Jan | 2249 | 1810 | 328 | 27190
East |  |  |  |  |  |  |  | 20-Jan | 4206 | 3117 | 307 | 31396
South |  |  |  |  |  |  |  | 21-Jan | 1191 | 986 | 64 | 32587
West |  |  |  |  |  |  |  | 22-Jan | 4661 | 3495 | 483 | 37248
North |  |  |  |  |  |  |  | 23-Jan | 5037 | 4125 | 151 | 42285
East |  |  |  |  |  |  |  | 24-Jan | 5136 | 4102 | 563 | 47421
South |  |  |  |  |  |  |  | 27-Jan | 1577 | 1167 | 219 | 48998
West |  |  |  |  |  |  |  | 28-Jan | 1813 | 1503 | 202 | 50811
North |  |  |  |  |  |  |  | 29-Jan | 3202 | 2514 | 190 | 54013
East |  |  |  |  |  |  |  | 30-Jan | 3316 | 2656 | 272 | 57329
South |  |  |  |  |  |  |  | 31-Jan | 567 | 403 | 11 | 57896
West |  |  |  |  |  |  |  | Feb | 44784 | 35568 | 3867
North |  |  |  |  |  |  |  | 2-Feb | 1867 | 1371 | 101 | 1867
East |  |  |  |  |  |  |  | 3-Feb | 2175 | 1824 | 123 | 4042
South |  |  |  |  |  |  |  | 5-Feb | 1242 | 893 | 32 | 5284
West |  |  |  |  |  |  |  | 6-Feb | 2378 | 1935 | 149 | 7662
North |  |  |  |  |  |  |  | 7-Feb | 2230 | 1680 | 214 | 9892
East |  |  |  |  |  |  |  | 8-Feb | 929 | 812 | 121 | 10821
South |  |  |  |  |  |  |  | 12-Feb | 2266 | 1889 | 259 | 13087
West |  |  |  |  |  |  |  | 13-Feb | 1478 | 1134 | 47 | 14565
North |  |  |  |  |  |  |  | 14-Feb | 5106 | 4117 | 699 | 19671
East |  |  |  |  |  |  |  | 15-Feb | 2427 | 1940 | 245 | 22098
South |  |  |  |  |  |  |  | 16-Feb | 4482 | 3595 | 216 | 26580
West |  |  |  |  |  |  |  | 17-Feb | 1109 | 996 | 19 | 27689
North |  |  |  |  |  |  |  | 18-Feb | 615 | 478 | 108 | 28304
East |  |  |  |  |  |  |  | 20-Feb | 2778 | 2371 | 416 | 31082
South |  |  |  |  |  |  |  | 24-Feb | 5079 | 3973 | 315 | 36161
West |  |  |  |  |  |  |  | 25-Feb | 1929 | 1467 | 272 | 38090
North |  |  |  |  |  |  |  | 27-Feb | 4232 | 3292 | 159 | 42322
East |  |  |  |  |  |  |  | 28-Feb | 2462 | 1801 | 372 | 44784
South |  |  |  |  |  |  |  | Mar | 42071 | 33788 | 4243
West |  |  |  |  |  |  |  | 3-Mar | 2427 | 1999 | 254 | 2427
North |  |  |  |  |  |  |  | [NAME] | 556 | 422 | 65 | 2983
East |  |  |  |  |  |  |  | 5-Mar | 685 | 497 | 90 | 3668
South |  |  |  |  |  |  |  | 6-Mar | 1418 | 1139 | 85 | 5086
West |  |  |  |  |  |  |  | 7-Mar | 2734 | 2361 | 255 | 7820
North |  |  |  |  |  |  |  | 8-Mar | 1142 | 1017 | 176 | 8962
East |  |  |  |  |  |  |  | 9-Mar | 4028 | 3371 | 526 | 12990
South |  |  |  |  |  |  |  | 10-Mar | 1775 | 1372 | 287 | 14765
West |  |  |  |  |  |  |  | 11-Mar | 1665 | 1198 | 137 | 16430
North |  |  |  |  |  |  |  | 13-Mar | 555 | 405 | 90 | 16985
East |  |  |  |  |  |  |  | 14-Mar | 890 | 708 | 38 | 17875
South |  |  |  |  |  |  |  | 15-Mar | 3546 | 3088 | 468 | 21421
West |  |  |  |  |  |  |  | 16-Mar | 3707 | 3228 | 196 | 25128
North |  |  |  |  |  |  |  | 18-Mar | 1003 | 720 | 141 | 26131
East |  |  |  |  |  |  |  | 20-Mar | 697 | 535 | 5 | 26828
South |  |  |  |  |  |  |  | 21-Mar | 2845 | 2183 | 305 | 29673
West |  |  |  |  |  |  |  | 22-Mar | 885 | 632 | 28 | 30558
North |  |  |  |  |  |  |  | 24-Mar | 1501 | 1055 | 102 | 32059
East |  |  |  |  |  |  |  | 26-Mar | 2400 | 1933 | 326 | 34459
South |  |  |  |  |  |  |  | 27-Mar | 2735 | 2082 | 179 | 37194
West |  |  |  |  |  |  |  | 29-Mar | 2000 | 1651 | 107 | 39194
North |  |  |  |  |  |  |  | 30-Mar | 1595 | 1255 | 177 | 40789
East |  |  |  |  |  |  |  | 31-Mar | 1282 | 937 | 206 | 42071
South |  |  |  |  |  |  |  | Apr | 42909 | 33919 | 4565
West |  |  |  |  |  |  |  | 1-Apr | 4331 | 3498 | 513 | 4331
North |  |  |  |  |  |  |  | 2-Apr | 613 | 495 | 103 | 4944
East |  |  |  |  |  |  |  | 3-Apr | 3155 | 2354 | 322 | 8099
South |  |  |  |  |  |  |  | 4-Apr | 928 | 811 | 146 | 9027
West |  |  |  |  |  |  |  | 7-Apr | 1100 | 844 | 57 | 10127
North |  |  |  |  |  |  |  | 8-Apr | 2290 | 1639 | 222 | 12417
East |  |  |  |  |  |  |  | 9-Apr | 2063 | 1676 | 222 | 14480
South |  |  |  |  |  |  |  | 10-Apr | 906 | 768 | 43 | 15386
West |  |  |  |  |  |  |  | 11-Apr | 893 | 691 | 112 | 16279
North |  |  |  |  |  |  |  | 14-Apr | 1764 | 1527 | 100 | 18043
East |  |  |  |  |  |  |  | 15-Apr | 2145 | 1689 | 276 | 20188
South |  |  |  |  |  |  |  | 17-Apr | 765 | 551 | 55 | 20953
West |  |  |  |  |  |  |  | 18-Apr | 2473 | 2104 | 363 | 23426
North |  |  |  |  |  |  |  | 19-Apr | 3649 | 2918 | 534 | 27075
East |  |  |  |  |  |  |  | 20-Apr | 610 | 509 | 94 | 27685
South |  |  |  |  |  |  |  | 22-Apr | 4710 | 3736 | 445 | 32395
West |  |  |  |  |  |  |  | 24-Apr | 2932 | 2110 | 325 | 35327
North |  |  |  |  |  |  |  | 25-Apr | 1004 | 703 | 17 | 36331
East |  |  |  |  |  |  |  | 26-Apr | 2232 | 1805 | 415 | 38563
South |  |  |  |  |  |  |  | 27-Apr | 762 | 558 | 16 | 39325
West |  |  |  |  |  |  |  | 28-Apr | 2104 | 1633 | 78 | 41429
North |  |  |  |  |  |  |  | 30-Apr | 1480 | 1300 | 107 | 42909
East |  |  |  |  |  |  |  | May | 57577 | 46476 | 5964
South |  |  |  |  |  |  |  | 1-May | 3085 | 2433 | 571 | 3085
West |  |  |  |  |  |  |  | 2-May | 1361 | 1008 | 126 | 4446
North |  |  |  |  |  |  |  | 3-May | 4318 | 3760 | 353 | 8764
East |  |  |  |  |  |  |  | 4-May | 1869 | 1486 | 97 | 10633
South |  |  |  |  |  |  |  | 5-May | 3783 | 3012 | 227 | 14416
West |  |  |  |  |  |  |  | 6-May | 3545 | 2982 | 373 | 17961
North |  |  |  |  |  |  |  | 8-May | 1781 | 1495 | 214 | 19742
East |  |  |  |  |  |  |  | 9-May | 1812 | 1333 | 333 | 21554
South |  |  |  |  |  |  |  | 11-May | 2649 | 2074 | 192 | 24203
West |  |  |  |  |  |  |  | 13-May | 1983 | 1662 | 109 | 26186
North |  |  |  |  |  |  |  | 14-May | 2503 | 2081 | 340 | 28689
East |  |  |  |  |  |  |  | 15-May | 3203 | 2346 | 492 | 31892
South |  |  |  |  |  |  |  | 17-May | 2594 | 2145 | 150 | 34486
West |  |  |  |  |  |  |  | 18-May | 3201 | 2589 | 277 | 37687
North |  |  |  |  |  |  |  | 19-May | 3688 | 3168 | 577 | 41375
East |  |  |  |  |  |  |  | 20-May | 560 | 393 | 91 | 41935
South |  |  |  |  |  |  |  | 21-May | 3578 | 2869 | 135 | 45513
West |  |  |  |  |  |  |  | 24-May | 752 | 579 | 136 | 46265
North |  |  |  |  |  |  |  | 25-May | 518 | 387 | 3 | 46783
East |  |  |  |  |  |  |  | 26-May | 2201 | 1794 | 235 | 48984
South |  |  |  |  |  |  |  | 27-May | 3997 | 3069 | 412 | 52981
West |  |  |  |  |  |  |  | 28-May | 2492 | 2209 | 200 | 55473
North |  |  |  |  |  |  |  | 29-May | 2104 | 1602 | 321 | 57577
East |  |  |  |  |  |  |  | Jun | 46312 | 37838 | 5092
South |  |  |  |  |  |  |  | 1-Jun | 3341 | 2730 | 301 | 3341
West |  |  |  |  |  |  |  | 2-Jun | 1091 | 840 | 38 | 4432
North |  |  |  |  |  |  |  | 3-Jun | 2352 | 1849 | 92 | 6784
East |  |  |  |  |  |  |  | [NAME] | 2167 | 1671 | 243 | 8951
South |  |  |  |  |  |  |  | 5-Jun | 921 | 675 | 115 | 9872
West |  |  |  |  |  |  |  | 6-Jun | 1228 | 919 | 165 | 11100
North |  |  |  |  |  |  |  | 7-Jun | 3092 | 2622 | 282 | 14192
East |  |  |  |  |  |  |  | [NAME] | 1674 | 1177 | 334 | 15866
South |  |  |  |  |  |  |  | 9-Jun | 3111 | 2707 | 437 | 18977
West |  |  |  |  |  |  |  | 10-Jun | 1320 | 1187 | 155 | 20297
North |  |  |  |  |  |  |  | 12-Jun | 624 | 483 | 54 | 20921
East |  |  |  |  |  |  |  | 13-Jun | 1319 | 1139 | 222 | 22240
South |  |  |  |  |  |  |  | 14-Jun | 1371 | 1126 | 170 | 23611
West |  |  |  |  |  |  |  | 16-Jun | 751 | 659 | 80 | 24362
North |  |  |  |  |  |  |  | 17-Jun | 1213 | 1033 | 229 | 25575
East |  |  |  |  |  |  |  | 22-Jun | 1009 | 773 | 35 | 26584
South |  |  |  |  |  |  |  | 23-Jun | 507 | 411 | 18 | 27091
West |  |  |  |  |  |  |  | 24-Jun | 3724 | 3106 | 472 | 30815
North |  |  |  |  |  |  |  | 25-Jun | 3413 | 2674 | 463 | 34228
East |  |  |  |  |  |  |  | 26-Jun | 3167 | 2721 | 384 | 37395
South |  |  |  |  |  |  |  | 27-Jun | 1018 | 743 | 152 | 38413
West |  |  |  |  |  |  |  | 28-Jun | 3810 | 3162 | 205 | 42223
North |  |  |  |  |  |  |  | 29-Jun | 4089 | 3431 | 446 | 46312
East |  |  |  |  |  |  |  | Jul | 6351 | 4917 | 422
South |  |  |  |  |  |  |  | 1-Jul | 1707 | 1287 | 64 | 1707
West |  |  |  |  |  |  |  | 4-Jul | 3856 | 3039 | 306 | 5563
North |  |  |  |  |  |  |  | 5-Jul | 788 | 591 | 52 | 6351
East |  |  |  |  |  |  |  | Grand Total | 297900 | 238404 | 29526
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West
North
East
South
West