[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 75 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ward, Kaitlyn,25410 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Chandra, Tammy,12474 | 5928.25 | 0.00 | 3578.27 | 0.00 | 2349.98 |
| Kapoor, Carla,27001 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Xu, Jon, D,16572 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Foster, Sam, J,16355 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Bell, Devin,28429 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Coleman, Melissa,23698 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Nath, Brendan, C,22380 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Dylan,25855 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| Carlson, Neil, M,19226 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Hernandez, James,26812 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Watson, Zoe, W,26515 | 89.46 | 0.00 | 0.00 | 0.00 | 89.46 |
| Mitchell, Gabriel, J,26565 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Morris, Brooke,27057 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Long, Isabella, C,23060 | 126.93 | 0.00 | 0.00 | 0.00 | 126.93 |
| Flores, Carson, J,25375 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Malhotra, Shane, E,23603 | 2372.95 | 0.00 | 0.00 | 0.00 | 2372.95 |
| Long, Lauren, C,19143 | 605.21 | 0.00 | 0.00 | 0.00 | 605.21 |
| Morgan, Michelle, C,23217 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Chande, Mario, P,23256 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Chande, Roger,19473 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Morris, Alex,26550 | 93.48 | 0.00 | 0.00 | 0.00 | 93.48 |
| Sara, Rebekah, L,27257 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Hall, Alexis, H,22890 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Henderson, Jonathan, M,11143 | 48.56 | 0.00 | 0.00 | 0.00 | 48.56 |
| Gao, Clayton, C,22827 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Bryant, Dylan, J,14614 | 1645.55 | 0.00 | 699.10 | 0.00 | 946.45 |
| Shan, Ashlee, D,15633 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Bell, Charles, J,25314 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rogers, Chloe, M,20439 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
Generated 2025-12-21 22:37:56.718 UTC