Spreadsheet: 808794d1670662468-2-formulas-subtract-from-specific-columns-formulatest-gk-
Sheet: Pivot

 |  | Values
Department | Name | Sum of Target | Sum of Jun-22 | Sum of Jul-22 | Sum of Aug-22 | Sum of Sep-22 | Sum of Oct-22 | Sum of Nov-22 | Sum of Dec-22 | Sum of Field2 | Sum of Dec-Nov | Sum of Dec-Target
DepC | Person19 | 68 | 1515 | 2351 | 2303 | 2224 | 2033 | 2026 | 2175 | 660 | 149 | 2107 |  |  | 2039
 | Person21 | 9 | 1854 | 2324 | 1614 | 2223 | 2319 | 1766 | 2047 | 193 | 281 | 2038 |  | 1757 | 2029
 | Person23 | 4987 | 2069 | 1812 | 2400 | 1712 | 2312 | 2335 | 1818 | -251 | -517 | -3169 |  | -2652 | -8156
 | Person25 | 9848 | 1952 | 1549 | 1793 | 2343 | 1512 | 2067 | 1763 | -189 | -304 | -8085 |  | -7781 | -17933
 | Person27 | 18 | 2126 | 2012 | 1851 | 2415 | 2045 | 2395 | 1988 | -138 | -407 | 1970 |  | 2377 | 1952
DepC Total |  | 14930 | 9516 | 10048 | 9961 | 10917 | 10221 | 10589 | 9791 | 275 | -798 | -5139 |  | -4341 | -20069
[NAME] | [NAME] | 897 | 1522 | 2197 | 1628 | 2211 | 2276 | 2118 | 2359 | 837 | 241 | 1462 |  | 1221 | 565
 | Person22 | 598 | 1807 | 1754 | 2188 | 2036 | 1795 | 1529 | 2072 | 265 | 543 | 1474 |  | 931 | 876
 | Person24 | 98 | 2406 | 1649 | 1761 | 2191 | 1688 | 1983 | 1530 | -876 | -453 | 1432 |  | 1885 | 1334
 | Person26 | 99 | 2484 | 2399 | 1784 | 1517 | 2353 | 2365 | 1886 | -598 | -479 | 1787 |  | 2266 | 1688
 | Person28 | 9 | 1726 | 2330 | 1500 | 2244 | 2455 | 2199 | 2091 | 365 | -108 | 2082 |  | 2190 | 2073
[NAME] |  | 1701 | 9945 | 10329 | 8861 | 10199 | 10567 | 10194 | 9938 | -7 | -256 | 8237 |  | 8493 | 6536
DeptA | Person1 | 5250 | 5879 | 6917 | 5795 | 5472 | 5871 | 5545 | 5494 | -385 | -51 | 244 |  | 295 | -5006
 | Person11 | 1255 | 2091 | 1849 | 1586 | 2076 | 1638 | 2297 | 1943 | -148 | -354 | 688 |  | 1042 | -567
 | [NAME] | 654 | 2335 | 2472 | 2031 | 1855 | 2421 | 1684 | 1655 | -680 | -29 | 1001 |  | 1030 | 347
 | Person15 | 651 | 1850 | 2114 | 2374 | 2423 | 2123 | 2160 | 2252 | 402 | 92 | 1601 |  | 1509 | 950
 | Person17 | 651 | 1953 | 1551 | 1674 | 1525 | 1812 | 1794 | 1954 | 1 | 160 | 1303 |  | 1143 | 652
 | Person7 | 2485 | 2115 | 1539 | 2495 | 2059 | 1569 | 2387 | 1647 | -468 | -740 | -838 |  | -98 | -3323
 | Person9 | 251 | 2077 | 2245 | 2361 | 2313 | 1512 | 2399 | 1640 | -437 | -759 | 1389 |  | 2148 | 1138
DeptA Total |  | 11197 | 18300 | 18687 | 18316 | 17723 | 16946 | 18266 | 16585 | -1715 | -1681 | 5388 |  | 7069 | -5809
DeptB | Person1 | 1750 | 2499 | 2433 | 2196 | 2047 | 2128 | 2500 | 2498 | -1 | -2 | 748 |  | 750 | -1002
 | Person10 | 25455 | 1890 | 2344 | 2241 | 2349 | 1543 | 2059 | 1966 | 76 | -93 | -23489 |  | -23396 | -48944
 | Person12 | 255 | 2335 | 2093 | 1857 | 1922 | 2437 | 2215 | 1611 | -724 | -604 | 1356 |  | 1960 | 1101
 | Person14 | 654 | 2015 | 1980 | 2418 | 1507 | 1582 | 1988 | 2391 | 376 | 403 | 1737 |  | 1334 | 1083
 | Person16 | 651 | 1927 | 2137 | 2495 | 1540 | 2298 | 2314 | 2293 | 366 | -21 | 1642 |  | 1663 | 991
 | Person18 | 651 | 1871 | 2455 | 2449 | 2224 | 1987 | 1561 | 2195 | 324 | 634 | 1544 |  | 910 | 893
 | Person2 | 1300 | 2322 | 2073 | 1579 | 1974 | 2115 | 1637 | 1520 | -802 | -117 | 220 |  | 337 | -1080
 | Person6 | 1250 | 1720 | 1622 | 1611 | 1787 | 2445 | 2345 | 1865 | 145 | -480 | 615 |  | 1095 | -635
 | Person8 | 2552 | 1749 | 1679 | 2371 | 1628 | 1935 | 1633 | 2359 | 610 | 726 | -193 |  | -919 | -2745
DeptB Total |  | 34518 | 18328 | 18816 | 19217 | 16978 | 18470 | 18252 | 18698 | 370 | 446 | -15820 |  | -16266 | -50338
Grand Total |  | 62346 | 56089 | 57880 | 56355 | 55817 | 56204 | 57301 | 55012 | -1077 | -2289 | -7334 |  | -5045 | -69680