[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 62 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ramirez, Jasmine,27237 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Rodriguez, Jillian,20940 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Edwards, Caleb,21610 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Lu, Susan, C,12357 | 24.49 | 0.00 | 0.00 | 0.00 | 24.49 |
| Baker, Jack, W,17866 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Phillips, Luke, H,22790 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Lopez, Katherine,17161 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Zeng, Kristen, A,17541 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| White, Noah, M,17580 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
| Campbell, Fernando,23366 | 59.25 | 0.00 | 0.00 | 0.00 | 59.25 |
| Coleman, Melissa,23698 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Peterson, Grace, Y,22329 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Garcia, Grace,21734 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Wood, Alexandra, C,28797 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Gonzalez, Katelyn,22228 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Martin, Nelson,28450 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Tang, Tamara,28470 | 3399.99 | 0.00 | 3399.99 | 0.00 | 0.00 |
| Collins, Gabriella, J,13592 | 9695.73 | 0.00 | 2443.35 | 0.00 | 7252.38 |
| Taylor, Jasmine, A,11137 | 202.57 | 0.00 | 0.00 | 0.00 | 202.57 |
| Bryant, Alexandria,18359 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Hernandez, Thomas,13377 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Alexander, Antonio,20176 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Tang, Kara,20591 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Barnes, Dakota,23558 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Hernandez, Jenna, E,26644 | 2805.43 | 0.00 | 0.00 | 2049.10 | 756.33 |
| Sanchez, Cole,12405 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Walker, Lucas,23089 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Bradley, Erin, S,13401 | 4798.34 | 0.00 | 0.00 | 2443.35 | 2354.99 |
| Flores, Nicole, E,26038 | 2503.03 | 0.00 | 0.00 | 0.00 | 2503.03 |
| Lopez, Nancy, L,24182 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
Generated 2025-12-23 03:50:41.945 UTC