Spreadsheet: 874925d1721440667-stuck-trying-to-figure-last-condition-with-let-and-filter-function-sampledata
Sheet: SaleData

OrderDate | Region | Manager | SalesMan | Item | Units | Unit_price | Sale_amt |  | Item | Region | Units | Year | Month |  | Item | Units | OrderDate | Region
2018-01-06 00:00:00 | East | [NAME] | [NAME] | Television | 95 | 1198 |  |  | Cell Phone | Central | 20 | 2018 | Jan |  |  | 95 | 2018-01-06 00:00:00 | East
2018-01-23 00:00:00 | Central | Hermann | [NAME] | Home Theater | 50 | 500 |  |  | Desk |  | 20 | 2019 | Feb |  | Home Theater | 50 | 2018-01-23 00:00:00 | Central
2018-02-09 00:00:00 | Central | Hermann | [NAME] | Television | 36 | 1198 |  |  | Home Theater |  | 50 |  | Mar |  | Television | 36 | 2018-02-09 00:00:00 | Central
2018-02-26 00:00:00 | Central | Timothy | [NAME] | Cell Phone | 27 | 225 |  |  | Television |  | 50 |  | Apr |  | Cell Phone | 27 | 2018-02-26 00:00:00 | Central
2018-03-15 00:00:00 | West | Timothy | Stephen | Television | 56 | 1198 |  |  | Video Games |  | 75 |  | May |  | Television | 56 | 2018-03-15 00:00:00 | West
2018-04-01 00:00:00 | East | [NAME] | [NAME] | Home Theater | 60 | 500 |  |  |  |  | 75 |  | Jun |  | Home Theater | 60 | 2018-04-01 00:00:00 | East
2018-04-18 00:00:00 | Central | [NAME] | [NAME] | Television | 75 | 1198 |  |  |  |  |  |  | Jul |  | Television | 75 | 2018-04-18 00:00:00 | Central
2018-05-05 00:00:00 | Central | Hermann | [NAME] | Television | 90 | 1198 |  |  |  |  |  |  | Aug |  | Television | 90 | 2018-05-05 00:00:00 | Central
2018-05-22 00:00:00 | West | [NAME] | [NAME] | Television | 32 | 1198 |  |  |  |  |  |  | Sep |  | Television | 32 | 2018-05-22 00:00:00 | West
2018-06-08 00:00:00 | East | [NAME] | [NAME] | Home Theater | 60 | 500 |  |  |  |  |  |  | Oct |  | Home Theater | 60 | 2018-06-08 00:00:00 | East
2018-06-25 00:00:00 | Central | Hermann | Sigal | Television | 90 | 1198 |  |  |  |  |  |  | Nov |  | Television | 90 | 2018-06-25 00:00:00 | Central
2018-07-12 00:00:00 | East | [NAME] | [NAME] | Home Theater | 29 | 500 |  |  |  |  |  |  | Dec |  | Home Theater | 29 | 2018-07-12 00:00:00 | East
2018-07-29 00:00:00 | East | [NAME] | [NAME] | Home Theater | 81 | 500 |  |  |  |  |  |  |  |  | Home Theater | 81 | 2018-07-29 00:00:00 | East
2018-08-15 00:00:00 | East | [NAME] | [NAME] | Television | 35 | 1198 |  |  |  |  |  |  |  |  | Television | 35 | 2018-08-15 00:00:00 | East
2018-09-01 00:00:00 | Central | [NAME] | [NAME] | Desk | 2 | 125 |  |  |  |  |  |  |  |  | Desk | 2 | 2018-09-01 00:00:00 | Central
2018-09-18 00:00:00 | East | [NAME] | [NAME] | Video Games | 16 | 58.5 |  |  |  |  |  |  |  |  | Video Games | 16 | 2018-09-18 00:00:00 | East
2018-10-05 00:00:00 | Central | Hermann | Sigal | Home Theater | 28 | 500 |  |  |  |  |  |  |  |  | Home Theater | 28 | 2018-10-05 00:00:00 | Central
2018-10-22 00:00:00 | East | [NAME] | [NAME] | Cell Phone | 64 | 225 |  |  |  |  |  |  |  |  | Cell Phone | 64 | 2018-10-22 00:00:00 | East
2018-11-08 00:00:00 | East | [NAME] | [NAME] | Cell Phone | 15 | 225 |  |  |  |  |  |  |  |  | Cell Phone | 15 | 2018-11-08 00:00:00 | East
2018-11-25 00:00:00 | Central | Hermann | [NAME] | Video Games | 96 | 58.5 |  |  |  |  |  |  |  |  | Video Games | 96 | 2018-11-25 00:00:00 | Central
2018-12-12 00:00:00 | Central | [NAME] | [NAME] | Television | 67 | 1198 |  |  |  |  |  |  |  |  | Television | 67 | 2018-12-12 00:00:00 | Central
2018-12-29 00:00:00 | East | [NAME] | [NAME] | Video Games | 74 | 58.5 |  |  |  |  |  |  |  |  | Video Games | 74 | 2018-12-29 00:00:00 | East
2019-01-15 00:00:00 | Central | Timothy | [NAME] | Home Theater | 46 | 500 |  |  |  |  |  |  |  |  | Home Theater | 46 | 2019-01-15 00:00:00 | Central
2019-02-01 00:00:00 | Central | [NAME] | [NAME] | Home Theater | 87 | 500 |  |  |  |  |  |  |  |  | Home Theater | 87 | 2019-02-01 00:00:00 | Central
2019-02-18 00:00:00 | East | [NAME] | [NAME] | Home Theater | 4 | 500 |  |  |  |  |  |  |  |  | Home Theater | 4 | 2019-02-18 00:00:00 | East
2019-03-07 00:00:00 | West | Timothy | Stephen | Home Theater | 7 | 500 |  |  |  |  |  |  |  |  | Home Theater | 7 | 2019-03-07 00:00:00 | West
2019-03-24 00:00:00 | Central | Hermann | [NAME] | Video Games | 50 | 58.5 |  |  |  |  |  |  |  |  | Video Games | 50 | 2019-03-24 00:00:00 | Central
2019-04-10 00:00:00 | Central | [NAME] | [NAME] | Television | 66 | 1198 |  |  |  |  |  |  |  |  | Television | 66 | 2019-04-10 00:00:00 | Central
2019-04-27 00:00:00 | East | [NAME] | [NAME] | Cell Phone | 96 | 225 |  |  |  |  |  |  |  |  | Cell Phone | 96 | 2019-04-27 00:00:00 | East
2019-05-14 00:00:00 | Central | Timothy | [NAME] | Television | 53 | 1198 |  |  |  |  |  |  |  |  | Television | 53 | 2019-05-14 00:00:00 | Central
2019-05-31 00:00:00 | Central | Timothy | [NAME] | Home Theater | 80 | 500 |  |  |  |  |  |  |  |  | Home Theater | 80 | 2019-05-31 00:00:00 | Central
2019-06-17 00:00:00 | Central | Hermann | [NAME] | Desk | 5 | 125 |  |  |  |  |  |  |  |  | Desk | 5 | 2019-06-17 00:00:00 | Central
2019-07-04 00:00:00 | East | [NAME] | [NAME] | Video Games | 62 | 58.5 |  |  |  |  |  |  |  |  | Video Games | 62 | 2019-07-04 00:00:00 | East
2019-07-21 00:00:00 | Central | Hermann | Sigal | Video Games | 55 | 58.5 |  |  |  |  |  |  |  |  | Video Games | 55 | 2019-07-21 00:00:00 | Central
2019-08-07 00:00:00 | Central | Hermann | [NAME] | Video Games | 42 | 58.5 |  |  |  |  |  |  |  |  | Video Games | 42 | 2019-08-07 00:00:00 | Central
2019-08-24 00:00:00 | West | Timothy | Stephen | Desk | 3 | 125 |  |  |  |  |  |  |  |  | Desk | 3 | 2019-08-24 00:00:00 | West
2019-09-10 00:00:00 | Central | Timothy | [NAME] | Television | 7 | 1198 |  |  |  |  |  |  |  |  | Television | 7 | 2019-09-10 00:00:00 | Central
2019-09-27 00:00:00 | West | Timothy | Stephen | Cell Phone | 76 | 225 |  |  |  |  |  |  |  |  | Cell Phone | 76 | 2019-09-27 00:00:00 | West
2019-10-14 00:00:00 | West | [NAME] | [NAME] | Home Theater | 57 | 500 |  |  |  |  |  |  |  |  | Home Theater | 57 | 2019-10-14 00:00:00 | West
2019-10-31 00:00:00 | Central | [NAME] | [NAME] | Television | 14 | 1198 |  |  |  |  |  |  |  |  | Television | 14 | 2019-10-31 00:00:00 | Central
2019-11-17 00:00:00 | Central | Hermann | [NAME] | Home Theater | 11 | 500 |  |  |  |  |  |  |  |  | Home Theater | 11 | 2019-11-17 00:00:00 | Central
2019-12-04 00:00:00 | Central | Hermann | [NAME] | Home Theater | 94 | 500 |  |  |  |  |  |  |  |  | Home Theater | 94 | 2019-12-04 00:00:00 | Central
2019-12-21 00:00:00 | Central | [NAME] | [NAME] | Home Theater | 28 | 500 |  |  |  |  |  |  |  |  | Home Theater | 28 | 2019-12-21 00:00:00 | Central