[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 48 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hayes, Noah, E,28994 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Diaz, Alexis,11877 | 42.95 | 0.00 | 0.00 | 0.00 | 42.95 |
| Howard, Ian, L,28275 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Scott, Katherine,13380 | 4820.31 | 0.00 | 2443.35 | 0.00 | 2376.96 |
| Li, Adam,16985 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Rivera, Zoe,25413 | 1228.83 | 0.00 | 0.00 | 0.00 | 1228.83 |
| Shen, Alejandro, J,15442 | 93.48 | 0.00 | 0.00 | 0.00 | 93.48 |
| White, Noah, M,17580 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
| Watson, Brianna,28812 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Shen, Sheena,21771 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Rodriguez, Ethan, E,21695 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Sandberg, Isabella, D,21429 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Hernandez, Julia, L,22135 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Yuan, Damien, M,29442 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Patel, Frederick,22488 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-24 05:52:22.192 UTC