[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1031 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Adams, Jack,22191 | 94.46 | 0.00 | 0.00 | 0.00 | 94.46 | 0.00 |
| Moore, Jose, M,13161 | 4523.53 | 0.00 | 2181.56 | 0.00 | 2341.97 | 0.00 |
| Li, Alan, M,27773 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 | 0.00 |
| Bailey, Jessica, L,12945 | 321.39 | 0.00 | 0.00 | 0.00 | 218.44 | 102.95 |
| Washington, Jonathan, A,20761 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 | 0.00 |
| Zhang, Arturo, V,26891 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Anand, Tommy,17875 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 | 0.00 |
| Suri, Whitney, J,21974 | 4925.17 | 0.00 | 0.00 | 2443.35 | 2481.82 | 0.00 |
| Perry, Adam,14650 | 1538.58 | 0.00 | 699.10 | 0.00 | 839.48 | 0.00 |
| Diaz, Ricky, E,18335 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 | 0.00 |
| Holt, Brittney,19523 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 | 0.00 |
| Cai, Jorge,22031 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 | 0.00 |
| Johnson, Lucas,13509 | 48.96 | 0.00 | 0.00 | 0.00 | 48.96 | 0.00 |
| Ortega, Nelson,15118 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 | 0.00 |
| Sai, Regina,21192 | 4229.32 | 0.00 | 2443.35 | 0.00 | 1785.97 | 0.00 |
| Powell, Angela, R,12970 | 471.11 | 0.00 | 0.00 | 0.00 | 471.11 | 0.00 |
| Brown, Edward,27621 | 5971.33 | 3578.27 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Gill, Audrey, H,13717 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 | 0.00 |
| Taylor, Natalie, M,14338 | 828.74 | 0.00 | 0.00 | 0.00 | 828.74 | 0.00 |
| Martin, John, A,14436 | 4776.01 | 0.00 | 0.00 | 0.00 | 4776.01 | 0.00 |
| Brown, Marcus, J,17575 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 | 0.00 |
| Mitchell, Dalton, R,22259 | 562.96 | 0.00 | 0.00 | 562.96 | 0.00 | 0.00 |
| Washington, Caleb,26995 | 1145.48 | 0.00 | 0.00 | 1145.48 | 0.00 | 0.00 |
| Hernandez, Jeremiah, C,25303 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 | 0.00 |
| Zhang, Jose,23905 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 | 0.00 |
| Malhotra, Meredith,29314 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 | 0.00 |
| Zhao, Jamie,16179 | 72.16 | 0.00 | 0.00 | 0.00 | 72.16 | 0.00 |
| Zhou, Jamie,17327 | 99.94 | 0.00 | 0.00 | 0.00 | 99.94 | 0.00 |
Generated 2026-01-04 04:59:19.904 UTC