[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 82 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mehta, Kristi, D,22312 | 2478.24 | 0.00 | 0.00 | 2478.24 | 0.00 |
| Phillips, Mackenzie,12444 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Adams, Amanda, P,11971 | 134.46 | 0.00 | 0.00 | 0.00 | 134.46 |
| Morris, Timothy, M,18111 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kapoor, Manuel, R,12556 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Ross, Chloe, L,29404 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Nath, Karla,22317 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ward, Makayla, R,12052 | 5935.55 | 0.00 | 3578.27 | 0.00 | 2357.28 |
| Suri, Manuel, G,20469 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Sun, Susan,21835 | 2360.95 | 0.00 | 0.00 | 0.00 | 2360.95 |
| Hughes, Jose,26175 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Zeng, Roger,22377 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Hill, Elijah, E,18069 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Collins, Kaitlyn,26263 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Washington, Caleb,26995 | 1145.48 | 0.00 | 0.00 | 1145.48 | 0.00 |
| Deng, Bethany, A,19320 | 1981.96 | 0.00 | 0.00 | 1981.96 | 0.00 |
| Griffin, Ian,16968 | 2325.96 | 0.00 | 0.00 | 0.00 | 2325.96 |
| Sanchez, Cole,12405 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Kelly, Cody,23697 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Arthur, Johnathan,18730 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Perez, Tabitha, C,22632 | 2492.32 | 0.00 | 0.00 | 0.00 | 2492.32 |
| Russell, Dylan, W,19658 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Alonso, Gina, C,22587 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Bryant, Carson,11190 | 46.27 | 0.00 | 0.00 | 0.00 | 46.27 |
| Jenkins, Mariah, M,20530 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Richardson, Danielle,22884 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Huang, Glenn,14613 | 1601.56 | 0.00 | 699.10 | 0.00 | 902.46 |
| Rodriguez, Daniel, R,16889 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
Generated 2025-12-23 11:57:13.419 UTC