[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 250 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gill, Robin, J,12477 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Smith, Fernando,26534 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Zeng, Colin,21343 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Howard, Richard, D,15428 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 |
| Stone, Damien,20858 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Xu, Mandy,27899 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Barnes, Natalie,24295 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Taylor, Noah, E,18979 | 1749.96 | 0.00 | 0.00 | 0.00 | 1749.96 |
| Garcia, Stanley, R,19294 | 2820.39 | 0.00 | 0.00 | 1000.44 | 1819.95 |
| Guo, Vincent, F,18235 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Torres, Deanna, E,16994 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carlson, Mallory, A,19281 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Coleman, Brandon,29131 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Lal, Ethan, A,12414 | 157.29 | 0.00 | 0.00 | 0.00 | 157.29 |
| Hernandez, Kaylee, T,22007 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Torres, Jonathon, F,17273 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Henderson, Lauren, E,17131 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Roberts, Elijah,26728 | 4455.10 | 0.00 | 0.00 | 2049.10 | 2406.00 |
| Sanchez, Seth,17093 | 6917.59 | 0.00 | 0.00 | 2181.56 | 4736.03 |
| Alvarez, Dana,15067 | 2803.52 | 0.00 | 0.00 | 2181.56 | 621.96 |
| Butler, Edward, L,20655 | 47.42 | 0.00 | 0.00 | 0.00 | 47.42 |
| Sanchez, Geoffrey,18398 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Richardson, Bailey, G,23871 | 673.97 | 0.00 | 0.00 | 0.00 | 673.97 |
| Patel, Evelyn, W,18033 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Xu, Ernest, R,14827 | 4467.74 | 0.00 | 3578.27 | 0.00 | 889.47 |
| Gonzales, Megan,21828 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Yuan, Corey,27334 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Moore, Megan, I,23189 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Gray, Erin,16505 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hill, Amanda,21152 | 1134.47 | 0.00 | 0.00 | 0.00 | 1134.47 |
| Ward, Maria, A,24844 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
Generated 2025-12-22 00:32:40.274 UTC