[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Pal, Bethany, W,15714 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Mitchell, Haley, C,20462 | 2512.32 | 0.00 | 0.00 | 0.00 | 2512.32 |
| Ross, Mariah, J,12104 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Clark, Thomas, M,21439 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Barnes, Jordyn, L,25279 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Gutierrez, Briana, J,24442 | 82.59 | 0.00 | 0.00 | 0.00 | 82.59 |
| Davis, Jacob, F,20489 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Torres, Jasmine, A,11216 | 5948.24 | 0.00 | 3578.27 | 2369.97 | 0.00 |
| Yang, Jaclyn,14961 | 151.27 | 0.00 | 0.00 | 0.00 | 151.27 |
| Torres, Desiree, M,23852 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Cook, Chloe, L,26790 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Nara, Kurt,12219 | 2388.96 | 0.00 | 0.00 | 0.00 | 2388.96 |
| Jackson, Kaitlyn,27293 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Hall, Katherine,25959 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Henderson, Oscar, J,15852 | 3222.98 | 0.00 | 0.00 | 782.99 | 2439.99 |
| Peterson, Mariah,17432 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Washington, Kyle, C,29255 | 4389.59 | 0.00 | 3578.27 | 0.00 | 811.32 |
| Johnson, Devin,15985 | 3179.95 | 0.00 | 0.00 | 782.99 | 2396.96 |
| Yuan, Priscilla, L,17107 | 4179.33 | 0.00 | 0.00 | 4179.33 | 0.00 |
| Thomas, Kaitlyn,19896 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lal, Dawn,12618 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| Mr., Rothenberg, Eric,20668 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Clark, Chloe, K,24340 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Butler, Richard, C,17593 | 2380.47 | 0.00 | 0.00 | 0.00 | 2380.47 |
| Simmons, Eric, M,14643 | 1613.06 | 0.00 | 699.10 | 0.00 | 913.96 |
| Ramirez, Caitlin,27912 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Subram, Kristopher,12824 | 44.54 | 0.00 | 0.00 | 0.00 | 44.54 |
| Bailey, Kaylee,29224 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Rubio, Theresa,21743 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Lal, Nathan, E,11273 | 273.23 | 0.00 | 0.00 | 0.00 | 273.23 |
| Deng, Dawn, L,16439 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
Generated 2025-12-20 23:44:58.573 UTC