[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Rodriguez, Kayla, W,28197 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Peterson, Garrett,26006 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 | 0.00 |
| Malhotra, Adriana,19145 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 | 0.00 |
| Vazquez, Marc, H,24362 | 3600.77 | 0.00 | 0.00 | 2443.35 | 1157.42 | 0.00 |
| Yuan, Leonard, F,16791 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 | 0.00 |
| Long, James, Y,21844 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Lopez, Kristina, L,20247 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 | 0.00 |
| Hughes, Jordan,26244 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 | 0.00 |
| Xu, Carly, G,28847 | 4355.61 | 0.00 | 3578.27 | 0.00 | 777.34 | 0.00 |
| Zhang, Elijah,28789 | 7.95 | 0.00 | 0.00 | 0.00 | 0.00 | 7.95 |
| Madan, Terrance,24910 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 | 0.00 |
| Russell, Devin, A,22072 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 | 0.00 |
| Peterson, Lucas,17298 | 174.45 | 0.00 | 0.00 | 0.00 | 174.45 | 0.00 |
| Reed, Arianna, H,28673 | 4380.10 | 0.00 | 3578.27 | 0.00 | 801.83 | 0.00 |
| Chander, Bethany, K,11446 | 8237.01 | 0.00 | 3399.99 | 2354.98 | 2482.04 | 0.00 |
| Bryant, Sydney, S,11412 | 9879.96 | 0.00 | 3374.99 | 0.00 | 6504.97 | 0.00 |
| Mr., Robinett, David, R.,11377 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 | 0.00 |
| Davis, Samantha, P,28244 | 6026.31 | 0.00 | 3578.27 | 0.00 | 2448.04 | 0.00 |
| Yuan, Dawn, A,18801 | 1799.48 | 0.00 | 0.00 | 0.00 | 1799.48 | 0.00 |
| Zhu, Clarence, A,18462 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 | 0.00 |
| Powell, Alexandria,22733 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 | 0.00 |
| Jenkins, Connor,20800 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 | 0.00 |
| Rana, Nancy, H,26150 | 1992.46 | 0.00 | 0.00 | 782.99 | 1209.47 | 0.00 |
| Chander, Shawn, S,20216 | 5338.74 | 0.00 | 3578.27 | 0.00 | 1760.47 | 0.00 |
Generated 2026-01-04 05:38:18.375 UTC