[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 16 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Amanda, J,24448 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Zhu, Susan, P,14971 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gutierrez, Mallory,21827 | 2354.98 | 0.00 | 0.00 | 0.00 | 2354.98 |
| Morris, Cole, D,16728 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Tang, Tommy, L,29479 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Alexander, Hannah, A,23280 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Jackson, José, J,27538 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Morgan, Ian,21440 | 562.96 | 0.00 | 0.00 | 562.96 | 0.00 |
| Li, Rosa,17675 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Lewis, Daniel, W,18365 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rodriguez, Jermaine,16431 | 4769.40 | 0.00 | 0.00 | 2181.56 | 2587.84 |
| Parker, Hailey, J,14402 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Subram, Erick, S,20458 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Martinez, Regina, S,20345 | 2520.83 | 0.00 | 0.00 | 0.00 | 2520.83 |
| Ward, Arianna,13536 | 5973.24 | 0.00 | 3578.27 | 0.00 | 2394.97 |
| Thomas, Nicole,11795 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Butler, Caroline,11690 | 5904.23 | 0.00 | 3578.27 | 0.00 | 2325.96 |
| Hall, Angel, H,26807 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Green, Isaiah, J,23337 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Washington, Aidan,23444 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Martin, Nicole, I,21933 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Deng, Dawn, L,16439 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Perez, Ian, L,17469 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Morris, Erin,12195 | 124.41 | 0.00 | 0.00 | 0.00 | 124.41 |
| Vazquez, Kathleen, M,12500 | 4475.38 | 0.00 | 0.00 | 2071.42 | 2403.96 |
| White, Kaitlyn,20393 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Clark, Noah,18223 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jones, Olivia, A,21307 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Sharma, Colleen,13215 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Jenkins, Nicole, W,25076 | 2469.05 | 0.00 | 0.00 | 0.00 | 2469.05 |
Generated 2025-12-23 11:38:27.955 UTC