Spreadsheet: 731274d1620259849-formula-to-populate-orders-master-excel-forum
Sheet: Sales

Sales By Period
Visually Group By | Compare Values By | Summarise By | Show Values | Reporting Units
None | Month |  | Quantity (Inventory Unit) | each
Item Code | Item Description | Order Categories # [NAME] | Order Reference | Customer | Date | Planned Location | Units In Stock UOM | Apr (2021) | May (2021) | Jun (2021) | Jul (2021) | Aug (2021) | Sep (2021) | Oct (2021) | Nov (2021) | Dec (2021) | Total
AU-100071 | a | (not set) | NEW 2810 | x | 2021-06-01 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100071 | b | SOH | 2716 | x | 2021-05-03 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100071 | c | SOH | P5938 | x | 2021-05-03 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100085 | d | SOH | 141 | x | 2021-05-03 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100093 | a | 60305 | 150 | x | 2021-04-23 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100098 | b | (not set) | 45500230 | x | 2021-05-25 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100098 | c | (not set) | 45504908 | x | 2021-10-05 13:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100104 | d | (not set) | 30345 | x | 2021-05-19 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100104 | a | 60295 | 30263 | x | 2021-04-29 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100105 | b | 60295 | 30223 | x | 2021-04-29 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100117 | c | (not set) | PA061024 | x | 2021-07-12 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100190 | d | (not set) | 133 | x | 2021-06-15 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100190 | a | SOH | 133 | x | 2021-05-03 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100225 | b | (not set) | TBC 5706-2 | x | 2021-05-07 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100225 | c | (not set) | TBC 5706-3 | x | 2021-07-26 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100225 | d | (not set) | TBC 5706-4 | x | 2021-10-26 13:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100226 | a | (not set) | PA058865 | x | 2021-06-10 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100226 | b | (not set) | PA059721 | x | 2021-05-24 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100235 | c | (not set) | GWN5321/2 - FSPO60312 | x | 2021-05-28 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100247 | d | (not set) | NEW PO-0173 | x | 2021-07-01 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100247 | a | (not set) | NEW PO-0173-2 | x | 2021-10-01 13:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100247 | b | 60315 | 0142-2 | x | 2021-05-14 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100267 | c | (not set) | NEW PO-0174-1 | x | 2021-05-10 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100268 | d | (not set) | NEW PO-0174-2 | x | 2021-06-01 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100303 | a | (not set) | 45503810-2 FSPO60317 | x | 2021-06-02 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100307 | b | SOH | 0126-2 | x | 2021-05-03 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100003 | c | (not set) | Deliver on [NAME] | x | 2021-05-05 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100020 | d | (not set) | 26801 | x | 2021-05-15 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100021 | a | (not set) | 26801 | x | 2021-05-15 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100026 | b | (not set) | NEW PO15164 | x | 2021-05-11 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100026 | c | (not set) | PO15163 | x | 2021-05-07 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100028 | d | (not set) | 4004691 | x | 2021-07-06 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100028 | a | (not set) | 4004691 | x | 2021-09-07 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100034 | b | (not set) | NEW P-42043 | x | 2021-06-03 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100034 | c | (not set) | NEW P-42044 | x | 2021-07-01 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100034 | d | 60306 | 42042 | x | 2021-05-13 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100035 | a | (not set) | P103125 | x | 2021-09-01 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100035 | b | (not set) | P103126 | x | 2021-11-01 13:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100038 | c | (not set) | 4004737 | x | 2021-08-04 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100052 | d | SOH | 027435-1 | x | 2021-05-03 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100067 | a | (not set) | 640514 | x | 2021-08-04 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100067 | b | 60276 | 639936 | x | 2021-04-30 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100067 | c | 60276 | 640105-2 | x | 2021-04-30 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100070 | d | (not set) | 5255 | x | 2021-05-07 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100082 | a | (not set) | 640277 | x | 2021-06-01 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100082 | b | (not set) | 640678 | x | 2021-07-05 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100082 | c | (not set) | 640679 | x | 2021-09-13 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100082 | d | (not set) | 640680 | x | 2021-10-11 13:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100082 | a | SOH | 640677 | x | 2021-04-30 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | b | (not set) | Tapi | x | 2021-06-03 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100090 | c | (not set) | NEW PO Chick2 | x | 2021-05-21 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100113 | d | (not set) | 1458-3 | x | 2021-08-10 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100113 | a | (not set) | 1458-6 | x | 2021-12-10 13:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100196 | b | (not set) | 26801 | x | 2021-05-15 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100213 | c | (not set) | 27710 please delivery on arrival TIL | x | 2021-05-28 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100221 | d | (not set) | 4500395190 | x | 2021-07-07 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100221 | a | SOH | 4500391783 | x | 2021-04-30 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100224 | b | (not set) | 4500393463 | x | 2021-07-01 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100224 | c | (not set) | See Notes in comments [PHONE] | x | 2021-06-01 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100224 | d | 60276 | 4500391613 | x | 2021-05-03 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100224 | a | N | NEW [PHONE] | x | 2021-09-20 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100224 | b | SOH | 027416-1 | x | 2021-04-30 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | c | (not set) | 4500392574 | x | 2021-05-17 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | d | (not set) | 4500393093 | x | 2021-06-07 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | a | (not set) | 4500393462 | x | 2021-07-01 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | b | (not set) | 4500395704 | x | 2021-08-05 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | c | 60276 | [PHONE]-2 | x | 2021-05-03 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100226 | d | (not set) | 4500394108 | x | 2021-07-15 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100226 | a | (not set) | NEW [PHONE] | x | 2021-09-27 13:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100229 | b | (not set) | 640418 | x | 2021-06-02 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100229 | c | (not set) | 640514 | x | 2021-08-04 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100231 | d | (not set) | 4500391784 | x | 2021-06-30 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100231 | a | (not set) | 4500393094 | x | 2021-06-07 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100231 | b | (not set) | 4500393465 | x | 2021-07-01 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100231 | c | (not set) | 640154-2 | x | 2021-06-16 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100231 | d | (not set) | 640154-3 | x | 2021-08-04 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100231 | a | (not set) | 640154-4 | x | 2021-09-15 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100231 | b | (not set) | 640154-5 | x | 2021-11-03 13:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | c | (not set) | 4500393464 | x | 2021-07-01 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | d | 60281 | 4500391331 | x | 2021-04-30 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | a | 60315 | Stock Transfer FSPO60315 | x | 2021-05-10 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100254 | b | (not set) | 4500395813 | x | 2021-08-16 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100254 | c | (not set) | NEW [PHONE] | x | 2021-08-27 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100254 | d | (not set) | NEW [PHONE] | x | 2021-08-30 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100298 | a | (not set) | SIFF_14/12/2020 | x | 2021-05-07 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100298 | b | N | NEW PO-1058 (TBC) | x | 2021-05-04 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100307 | c | (not set) | 1458 - 5 | x | 2021-11-10 13:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100307 | d | (not set) | 1458-1 | x | 2021-05-10 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100307 | a | (not set) | 1458-2 | x | 2021-06-10 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100307 | b | (not set) | 1458-4 | x | 2021-09-10 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100316 | c | (not set) | SIFF_14/12/2020 | x | 2021-05-07 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100316 | d | N | NEW PO-1058 (TBC) | x | 2021-05-04 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100317 | a | (not set) | SIFF_14/12/2020 | x | 2021-05-07 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100328 | b | (not set) | NEW 00005299 | x | 2021-05-21 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100390 | c | 60315 | Stock Transfer FSPO60315 | x | 2021-05-10 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100390 | d | SOH | 027416-1 | x | 2021-04-30 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100390 | a | SOH | 027435-1 | x | 2021-05-03 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100403 | b | (not set) | NEW Vit&Min#1 | x | 2021-05-07 12:00:00 | y | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0