[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 92 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wang, Thomas,21271 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Gonzalez, Adam, J,14852 | 1468.59 | 0.00 | 699.10 | 0.00 | 769.49 |
| Cook, Ariana,11525 | 5935.55 | 0.00 | 3578.27 | 0.00 | 2357.28 |
| Huang, Shannon, H,11515 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Hill, Jason, C,14920 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Torres, Javier, R,12274 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Xie, Damien,20553 | 2354.98 | 0.00 | 0.00 | 0.00 | 2354.98 |
| Phillips, Dalton,23159 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Huang, Aimee,23160 | 673.97 | 0.00 | 0.00 | 0.00 | 673.97 |
| Patel, Pedro,22075 | 144.45 | 0.00 | 0.00 | 0.00 | 144.45 |
| Jones, Anna, A,29045 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Sanders, Katherine,23205 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Watson, Sydney,28982 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Ross, Christian,11831 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Rivera, Mackenzie,21285 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Rubio, Carrie,23595 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Powell, Gabriel, M,15981 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Alonso, Dwayne, M,28512 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Goel, Clarence,17189 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Torres, Carol, A,18561 | 2389.96 | 0.00 | 0.00 | 0.00 | 2389.96 |
| Lal, Marshall, L,28088 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Patterson, Miranda,22749 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Perry, Karen, M,21929 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Cook, Alyssa, A,18609 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Washington, David,29060 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Yuan, Latoya,21070 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Sanz, Max, J,23908 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Parker, Jackson, M,16502 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhang, Kyle, C,11713 | 191.95 | 0.00 | 0.00 | 0.00 | 191.95 |
| Watson, Evan, A,27452 | 4544.47 | 0.00 | 0.00 | 2071.42 | 2473.05 |
Generated 2025-12-23 07:44:59.603 UTC