[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ma, Todd,19581 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Vance, Adriana,26983 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| Zheng, Brittney, B,27913 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Arthur, Abby,14800 | 4390.69 | 0.00 | 3578.27 | 0.00 | 812.42 |
| Ward, Allison,21909 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Hernandez, Joy, J,17340 | 29.26 | 0.00 | 0.00 | 0.00 | 29.26 |
| Sanchez, Harold, T,25257 | 147.28 | 0.00 | 0.00 | 0.00 | 147.28 |
| Jai, Zachary, M,18732 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Lewis, Dalton,16776 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Perez, Caleb,12943 | 105.95 | 0.00 | 0.00 | 0.00 | 105.95 |
| Rivera, María, R,19741 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gray, Alyssa, C,20193 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Patel, Evelyn, W,18033 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Romero, Joanna,21521 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Prasad, Deanna,18009 | 2435.08 | 0.00 | 699.10 | 0.00 | 1735.98 |
| Rivera, Mason, M,20473 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Sanz, Janet, J,17898 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Roberts, Miguel, C,13662 | 3021.04 | 0.00 | 2181.56 | 839.48 | 0.00 |
| Jai, Andres, B,24841 | 2319.26 | 0.00 | 0.00 | 0.00 | 2319.26 |
| Reed, Destiny,15385 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Cox, Cody,12426 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Sanchez, Sebastian,11736 | 166.45 | 0.00 | 0.00 | 0.00 | 166.45 |
| Mitchell, Natalie, M,23165 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Morris, Devin,15875 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Jordan, Joe, L,15199 | 3080.27 | 0.00 | 782.99 | 0.00 | 2297.28 |
| Johnsen, Marvin, T,22514 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Lopez, Sophia, C,13030 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Price, Gavin, J,24259 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Kovar, Troy, J,23604 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Miller, Jessica,13200 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Sanz, Albert, G,20161 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ye, Alan,20782 | 1197.41 | 0.00 | 0.00 | 0.00 | 1197.41 |
| Rogers, Jasmine, K,23243 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Gonzales, Elizabeth, E,19689 | 680.94 | 0.00 | 0.00 | 0.00 | 680.94 |
| Smith, Joseph, T,20513 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Cox, Jessica, B,28816 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Suri, Chelsea, L,26273 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Harrison, Kayla, M,20790 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Li, Mandy, L,17224 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Patterson, Olivia, G,20636 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Liu, Crystal,24548 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raman, Carolyn, V,24067 | 2492.32 | 0.00 | 0.00 | 0.00 | 2492.32 |
| Lal, Hunter,27573 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Alexander, James,26110 | 5759.06 | 0.00 | 3374.99 | 0.00 | 2384.07 |
| Powell, Nathan,28460 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Alexander, Isabelle, L,15992 | 3194.93 | 0.00 | 0.00 | 782.99 | 2411.94 |
| Watson, Joan, D,20532 | 93.46 | 0.00 | 0.00 | 0.00 | 93.46 |
| Evans, Evan,23181 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Liang, Willie, M,19484 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Diaz, James, W,21790 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Patterson, Fernando, E,26484 | 2813.77 | 0.00 | 0.00 | 2071.42 | 742.35 |
| Young, Janet,25466 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhao, Roger,22322 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Torres, Arthur,20594 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Evans, Amber,27933 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Wang, Aaron, V,12163 | 5944.73 | 0.00 | 3578.27 | 0.00 | 2366.46 |
| Lee, Julia,15407 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Stewart, Angel, J,11235 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Cai, Colin,17739 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 |
| Cook, Ian, K,27535 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Carlson, Danny,27859 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Wu, Autumn,22568 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
Generated 2025-12-19 02:24:05.640 UTC