[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 46 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Kapoor, Ronald,14192 | 9451.91 | 0.00 | 0.00 | 2181.56 | 7270.35 |
| Russell, Gavin,28232 | 143.78 | 0.00 | 0.00 | 0.00 | 143.78 |
| Sanchez, Kristi, M,27074 | 4433.17 | 0.00 | 0.00 | 2049.10 | 2384.07 |
| Rivera, Savannah,23182 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Sanchez, Arianna,27809 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Ms., Slaven, Lanna, A.,27934 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hernandez, Robin,22619 | 819.48 | 0.00 | 0.00 | 0.00 | 819.48 |
| Zhang, Jackson,14105 | 1784.91 | 0.00 | 0.00 | 1000.44 | 784.47 |
| Jordan, Joel, M,20593 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Simmons, Amanda, M,19213 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Howard, Patrick, L,12797 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Parker, Robert, C,14693 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rodriguez, Meredith,25679 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Davis, Victoria, J,13704 | 2736.53 | 0.00 | 0.00 | 2181.56 | 554.97 |
| Diaz, Ethan,21398 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Chen, Brent, A,22610 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Vazquez, Desiree,22490 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Serrano, Erik,26976 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Jenkins, Jonathan,24107 | 123.99 | 0.00 | 0.00 | 0.00 | 123.99 |
| Lewis, Dalton,16776 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Alvarez, Wendy, V,12129 | 8557.41 | 0.00 | 0.00 | 2071.42 | 6485.99 |
| Diaz, Elizabeth, T,27189 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Torres, Frank, M,16582 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Jai, Tony, E,20503 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Ramos, Theodore, I,16400 | 4958.28 | 0.00 | 0.00 | 4958.28 | 0.00 |
| Jenkins, Emily,26676 | 2805.43 | 0.00 | 0.00 | 2049.10 | 756.33 |
| Harris, Marcus, L,11135 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Alexander, Samuel,19551 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Blanco, Anne,20014 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Shan, Brendan, V,21032 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-22 03:18:54.697 UTC