[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 438 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martin, Ian, K,14709 | 4397.75 | 0.00 | 3578.27 | 0.00 | 819.48 |
| Rivera, Richard, L,25998 | 4649.83 | 0.00 | 3399.99 | 0.00 | 1249.84 |
| Clark, Elizabeth, J,26005 | 4623.83 | 0.00 | 3399.99 | 0.00 | 1223.84 |
| Green, Amanda,21808 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Anand, Casey, F,25522 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Ye, Jorge, R,16426 | 5768.36 | 0.00 | 0.00 | 2181.56 | 3586.80 |
| James, Natalie, M,21902 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Murphy, Danielle,20027 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Green, Mary, S,14750 | 1613.06 | 0.00 | 699.10 | 0.00 | 913.96 |
| Ross, Elijah, E,11325 | 6044.20 | 0.00 | 3578.27 | 2465.93 | 0.00 |
| Moore, Zachary, S,11625 | 5913.25 | 0.00 | 3578.27 | 0.00 | 2334.98 |
| Lewis, Taylor, G,11295 | 6058.25 | 0.00 | 3578.27 | 2479.98 | 0.00 |
| Alvarez, Andy,11329 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Anderson, Zachary,11324 | 5945.23 | 0.00 | 3578.27 | 0.00 | 2366.96 |
| Simmons, Riley, R,14801 | 4382.74 | 0.00 | 3578.27 | 0.00 | 804.47 |
| Harrison, Nelson, J,14823 | 4392.74 | 0.00 | 3578.27 | 0.00 | 814.47 |
| Ye, Clarence, P,26050 | 4624.83 | 0.00 | 3374.99 | 0.00 | 1249.84 |
| Chander, Jaclyn, A,12804 | 5948.23 | 0.00 | 3578.27 | 0.00 | 2369.96 |
| Rodriguez, Andrew, N,11812 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Wright, Maria, D,16376 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| James, Isaiah,14630 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hayes, Jack, L,13991 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Sanchez, Arthur,23912 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Suri, Preston,20971 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Arun, Ruben,20959 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Morgan, Brian, T,13181 | 185.96 | 0.00 | 0.00 | 0.00 | 185.96 |
| Wright, Angel,27845 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Taylor, Greg, M,11683 | 5897.23 | 0.00 | 3578.27 | 0.00 | 2318.96 |
| Pal, Grant,14754 | 1500.87 | 0.00 | 699.10 | 0.00 | 801.77 |
| Deng, Lindsey,12754 | 6503.20 | 0.00 | 3578.27 | 0.00 | 2924.93 |
Generated 2025-12-24 06:25:59.996 UTC