Spreadsheet: 836112d1689098556-grouping-data-when-filtering-filter-query
Sheet: Sheet1

 | 2 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 1 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | Sage Code | Total Opening Stock (SAGE stock) | 2023-07-03 00:00:00 | 2023-07-10 00:00:00 | 2023-07-17 00:00:00 | 2023-07-24 00:00:00 | 2023-07-31 00:00:00 | 2023-08-07 00:00:00 | 2023-08-14 00:00:00 | 2023-08-21 00:00:00 | 2023-08-28 00:00:00 | 2023-09-04 00:00:00
20 | Chickpeas | 38022.08 | 38022.08 | 32665.04 | 32665.04 | 32665.04 | 18814.91 | 18814.91 | 18814.91 | 18814.91 | 9581.49 | 8636.13
20 | Chickpeas | Plan: | 5357.04 | 0 | 0 | 13850.13 | 0 | 0 | 0 | 9233.42 | 945.36 | 1260.48
20 | Chickpeas | forecast: | 4161.2 | 1819.01 | 2149.28 | 2840.12 | 2199.78 | 2400.77 | 2422.99 | 2272.5 | 2383.6 | 2559.34
20 | Chickpeas | Existing/Potential POs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 | Chickpeas | Closing Stock vs Plan: | 32665.04 | 32665.04 | 32665.04 | 18814.91 | 18814.91 | 18814.91 | 18814.91 | 9581.49 | 8636.13 | 7375.65
20 | CS210RE
36 | Olives | 92186.12 | 92186.12 | 92186.12 | 68358.15999999999 | 49536.80999999999 | 27312.76999999999 | 9821.58999999999 | -10036.02000000001 | -29893.63000000001 | -56540.46000000001 | -76398.07
36 | Olives | Plan: | 0 | 43627.96000000001 | 18821.35 | 22224.04 | 17491.18 | 19857.61 | 19857.61 | 26646.83 | 19857.61 | 19857.61
36 | Olives | forecast: | 28101.23 | 27410.39 | 18980.93 | 21349.38 | 20011.13 | 21159.5 | 20713.08 | 19737.42 | 19658.64 | 22400.79
36 | Olives | Existing/Potential POs | 0 | 19800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
36 | Olives | Closing Stock vs Plan: | 92186.12 | 68358.15999999999 | 49536.80999999999 | 27312.76999999999 | 9821.58999999999 | -10036.02000000001 | -29893.63000000001 | -56540.46000000001 | -76398.07 | -96255.68000000001
36 | CS400CRAU
157 | Potatoes | 124864.25 | 124864.25 | 103152.28 | 53919.83 | 30412.08 | -827.2199999999975 | -41178.74000000001 | -68422.48000000001 | -95760.15000000001 | -102849.34 | -117552.92
157 | Potatoes | Plan: | 21711.97 | 49232.45 | 23507.75 | 31239.3 | 40351.52 | 27243.74 | 27337.67 | 7089.190000000001 | 14703.58 | 18172.93
157 | Potatoes | forecast: | 24194.55 | 21585.72 | 23930.94 | 22601.78000000001 | 23875.39000000001 | 22566.43 | 23269.39 | 23989.52 | 24936.9 | 24374.33
157 | Potatoes | Existing/Potential POs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
157 | Potatoes | Closing Stock vs Plan: | 103152.28 | 53919.83 | 30412.08 | -827.2199999999975 | -41178.74000000001 | -68422.48000000001 | -95760.15000000001 | -102849.34 | -117552.92 | -135725.85
157 | CSAU001WC
167 | [NAME] | 30983.81 | 30983.81 | 30983.81 | 20696.96 | 13642.11 | 13642.11 | 7406.369999999999 | 7406.369999999999 | 7406.369999999999 | 7406.369999999999 | 6765.019999999999
167 | [NAME] | Plan: | 0 | 10286.85 | 7054.85 | 0 | 6235.74 | 0 | 0 | 0 | 641.35 | 4157.16
167 | [NAME] | forecast: | 2977.48 | 2604.79 | 2867.39 | 2823.96 | 2779.52 | 2341.18 | 2123.02 | 2012.93 | 2123.02 | 1926.07
167 | [NAME] | Existing/Potential POs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
167 | [NAME] | Closing Stock vs Plan: | 30983.81 | 20696.96 | 13642.11 | 13642.11 | 7406.369999999999 | 7406.369999999999 | 7406.369999999999 | 7406.369999999999 | 6765.019999999999 | 2607.859999999999
167 | CSAU066BDL
193 | Butter Beans | 53609.76 | 53609.76 | 33443.85 | 14807.33 | 164.3499999999985 | -18472.17 | -24462.48 | -50420.49000000001 | -62401.11000000001 | -75047.32 | -75047.32
193 | Butter Beans | Plan: | 27765.91 | 18636.52 | 14642.98 | 18636.52 | 5990.31 | 25958.01 | 11980.62 | 12646.21 | 0 | 5990.31
193 | Butter Beans | forecast: | 28570.88 | 14285.44 | 7142.72 | 21434.22 | 14285.44 | 0 | 16208.48 | 6049.900000000001 | 16483.2 | 7142.72
193 | Butter Beans | Existing/Potential POs | 7600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
193 | Butter Beans | Closing Stock vs Plan: | 33443.85 | 14807.33 | 164.3499999999985 | -18472.17 | -24462.48 | -50420.49000000001 | -62401.11000000001 | -75047.32 | -75047.32 | -81037.63
193 | CSAU621
203 | [NAME] | 63306 | 63306 | 68840.62 | 51762.53 | 51762.53 | 49741.52 | 48263.89 | 46362.06 | 46362.06 | 46362.06 | 46362.06
203 | [NAME] | Plan: | 745.38 | 17078.09 | 0 | 2021.01 | 1477.63 | 1901.83 | 0 | 0 | 0 | 0
203 | [NAME] | forecast: | 524.19 | 633.27 | 628.22 | 632.26 | 626.2 | 556.51 | 528.23 | 510.0500000000001 | 544.39 | 519.14
203 | [NAME] | Existing/Potential POs | 6280 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
203 | [NAME] | Closing Stock vs Plan: | 68840.62 | 51762.53 | 51762.53 | 49741.52 | 48263.89 | 46362.06 | 46362.06 | 46362.06 | 46362.06 | 46362.06
203 | CSCL001W
312 | Tomatoes | 68236.3 | 68236.3 | 53365.66 | 50911.36 | 37867.21 | 32958.61 | 30695.2 | 30695.2 | 22032.43 | 22032.43 | 12678.82
312 | Tomatoes | Plan: | 20870.64 | 2454.3 | 13044.15 | 4908.6 | 2263.41 | 0 | 8662.77 | 0 | 9353.61 | 0
312 | Tomatoes | forecast: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
312 | Tomatoes | Existing/Potential POs | 6000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
312 | Tomatoes | Closing Stock vs Plan: | 53365.66 | 50911.36 | 37867.21 | 32958.61 | 30695.2 | 30695.2 | 22032.43 | 22032.43 | 12678.82 | 12678.82
312 | CSCL360F
314 | Grapes | 24058.72 | 24058.72 | 22794.72 | 15646.95 | 10798.95 | 7041.750000000001 | -711.0099999999993 | -8952.61 | -16219.56 | -25713.56 | -34596.51
314 | Grapes | Plan: | 6464 | 7147.77 | 4848 | 3757.2 | 7752.76 | 8241.6 | 7266.95 | 9494 | 8882.95 | 6625.6
314 | Grapes | forecast: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
314 | Grapes | Existing/Potential POs | 5200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
314 | Grapes | Closing Stock vs Plan: | 22794.72 | 15646.95 | 10798.95 | 7041.750000000001 | -711.0099999999993 | -8952.61 | -16219.56 | -25713.56 | -34596.51 | -41222.11
314 | CSCL363B
315 | Apples | 34050.56 | 34050.56 | 19406.87 | 12943.88 | 6650.57 | 6650.57 | 4575.02 | 984.4699999999993 | -5978.470000000001 | -10287.13 | -16580.44
315 | Apples | Plan: | 17643.69 | 6462.99 | 6293.309999999999 | 0 | 2075.55 | 3590.55 | 6962.940000000001 | 4308.66 | 6293.309999999999 | 3590.55
315 | Apples | forecast: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
315 | Apples | Existing/Potential POs | 3000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
315 | Apples | Closing Stock vs Plan: | 19406.87 | 12943.88 | 6650.57 | 6650.57 | 4575.02 | 984.4699999999993 | -5978.470000000001 | -10287.13 | -16580.44 | -20170.99
315 | CSCL363C