I'm trying to perform a PO split analysis on a rolling 7-day period by identifying which POs have the same vendor for the same amount. My data looks similar to this:
| PO Number | Vendor Name | Create Date | Amount | Company Code |
| 1 | ABC | 1/4/24 | 10 | L |
| 2 | DEF | 2/1/24 | 27 | J |
| 3 | ABC | 1/6/24 | 10 | L |
| 4 | GHI | 3/15/24 | 19 | P |
| 5 | JKL | 7/22/24 | 15 | N |
| 6 | ABC | 1/1/24 | 10 | L |
In this case the threshold for additional approval is 30. The goal is to identify that PO numbers 1, 3, and 6 are all by the same vendor, for the same amount, in a 7-day period where the total equals 30 but the POs were split to bypass additional approval. Thank you!
