| Product | Customer | Units | Revenue | Price | Pricing Type | ||
| 2/1/2024 | A | Jane | 10 | 100 | 10 | Standard | ||
| 2/1/2024 | B | Bob | 10 | 90 | 9 | Discount | ||
| 2/5/2024 | A | John | 20 | 200 | 10 | Standard | ||
| 2/7/2024 | A | Jane | 5 | 100 | 20 | Special | ||
| 2/7/2024 | A | Jane | 10 | 50 | 5 | Standard | ||
| 2/11/2024 | B | Emily | 5 | 100 | 20 | Standard | ||
| 2/19/2024 | B | Jane | 20 | 200 | 10 | Standard | ||
| 2/20/2024 | B | Bob | 10 | 50 | 5 | Standard | ||
| 2/25/2024 | A | Jane | 20 | 180 | 9 | Discount |
I want to figure out a formula or setup to determine how many units and how much Jane bought Product A before the special price and how many units and dollars she spent after. This is obviously just a sample list and I would like the formula or table to work for more orders from a longer timespan. Thanks for the help.
