[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1233 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Ms., King, Amber, S,15935 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Sanchez, Carlos, W,17570 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Long, James, Y,21844 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Russell, Riley, M,18539 | 2356.95 | 0.00 | 0.00 | 0.00 | 2356.95 | 0.00 |
| Serrano, Billy, P,24080 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 | 0.00 |
| Rivera, Lucas, L,24275 | 831.33 | 0.00 | 0.00 | 0.00 | 831.33 | 0.00 |
| Perez, Jillian, E,20827 | 11.94 | 0.00 | 0.00 | 0.00 | 11.94 | 0.00 |
| Phillips, Madeline, R,18403 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 | 0.00 |
| Zhao, Trisha, A,22710 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 | 0.00 |
| Howard, Evan, S,13700 | 4525.82 | 0.00 | 0.00 | 2181.56 | 2344.26 | 0.00 |
| Arun, Mayra,25745 | 2473.04 | 0.00 | 0.00 | 0.00 | 2473.04 | 0.00 |
| Sharma, Roger, L,19454 | 4363.90 | 0.00 | 699.10 | 0.00 | 3664.80 | 0.00 |
| Alvarez, Sabrina,27943 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Gonzalez, Erick, E,26399 | 2543.44 | 0.00 | 0.00 | 0.00 | 2543.44 | 0.00 |
| Liang, Leah,16412 | 4921.59 | 0.00 | 0.00 | 2443.35 | 2478.24 | 0.00 |
| Turner, Jesse,28099 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 | 0.00 |
| Sanchez, Ronald,20671 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 | 0.00 |
| Bennett, Julia,23577 | 94.46 | 0.00 | 0.00 | 0.00 | 94.46 | 0.00 |
| Turner, Edward, S,20474 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 | 0.00 |
| Wood, Abigail, H,21386 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 | 0.00 |
| Brooks, Dalton, C,13173 | 4598.01 | 0.00 | 2181.56 | 0.00 | 2416.45 | 0.00 |
| Jackson, Ethan, C,23274 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 | 0.00 |
| Watson, Amanda, A,14358 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 | 0.00 |
| Smith, Isabella, F,21434 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Coleman, Alexandra, A,19820 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Brooks, Jeremy,24713 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Torres, Briana,13685 | 2931.42 | 0.00 | 0.00 | 0.00 | 2931.42 | 0.00 |
| Jai, Kurt, L,12723 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Gutierrez, Jamie, A,24129 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 | 0.00 |
| Kelly, Garrett, S,12069 | 5897.53 | 0.00 | 3578.27 | 0.00 | 2319.26 | 0.00 |
Generated 2026-01-04 05:47:18.123 UTC