[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 18 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Wood, Chloe, L,23878 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 | 0.00 |
| Gray, Gabrielle, E,15560 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Davis, Daniel,11711 | 104.56 | 0.00 | 0.00 | 0.00 | 41.58 | 62.98 |
| Ross, Alyssa,16248 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Ortega, Jamie,14978 | 4209.21 | 0.00 | 3578.27 | 0.00 | 630.94 | 0.00 |
| Carter, Seth, A,20126 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Subram, Carolyn,26052 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 | 0.00 |
| Raje, Bethany, B,22704 | 41.93 | 0.00 | 0.00 | 0.00 | 41.93 | 0.00 |
| Ward, Bruce, R,28162 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Patel, Mayra, R,17784 | 3891.54 | 0.00 | 0.00 | 2181.56 | 1709.98 | 0.00 |
| Hughes, Kevin, A,25354 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 | 0.00 |
| Bailey, Juan, M,21243 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 | 0.00 |
| Zhao, Darryl,15656 | 2992.33 | 0.00 | 0.00 | 2443.35 | 548.98 | 0.00 |
| Richardson, Chloe, R,12115 | 89.98 | 0.00 | 0.00 | 0.00 | 89.98 | 0.00 |
| Kumar, Christy, J,28002 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Sara, Terrance,19255 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 | 0.00 |
| Goel, Corey,11594 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 | 0.00 |
| Harris, Brianna,28597 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 | 0.00 |
| Shen, Deborah,28433 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 | 0.00 |
| Mehta, Dominic,18619 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 | 0.00 |
| Lal, Latoya, S,26415 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Robinson, Megan, G,16490 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 | 0.00 |
| Hernandez, Katherine,24528 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 | 0.00 |
| Zhang, Brandon, R,29144 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Thompson, Emily,15489 | 1685.45 | 0.00 | 0.00 | 782.99 | 902.46 | 0.00 |
| Hu, Alisha, E,24136 | 2413.06 | 0.00 | 0.00 | 0.00 | 2413.06 | 0.00 |
| Harris, Xavier, L,28587 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Wang, Ryan, D,23454 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 | 0.00 |
| Nelson, Jason, R,25871 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 | 0.00 |
| Guo, Jenny, F,26776 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 | 0.00 |
Generated 2026-01-04 04:35:52.628 UTC