[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jackson, Olivia,27681 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Howard, Isabella, J,28869 | 4355.61 | 0.00 | 3578.27 | 0.00 | 777.34 |
| Wang, Austin, A,14632 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Carlson, Meredith, G,24691 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Edwards, Gabrielle,28297 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Lee, Seth, C,23006 | 39.47 | 0.00 | 0.00 | 0.00 | 39.47 |
| Diaz, Beth, P,21313 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gonzalez, Alex, A,14452 | 3377.40 | 0.00 | 0.00 | 1000.44 | 2376.96 |
| Suarez, Naomi,13834 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Baker, Marcus,17520 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Malhotra, Clifford, G,24792 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Kapoor, Kristopher, J,19126 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Romero, Victor, C,12211 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Phillips, Marcus,23477 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Jenkins, Grace,29143 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
Generated 2025-12-21 23:14:35.977 UTC