[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 125 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rivera, Angel,13316 | 4576.53 | 0.00 | 2181.56 | 0.00 | 2394.97 |
| James, Devin,20031 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Raji, Darrell, T,11592 | 2297.28 | 0.00 | 0.00 | 0.00 | 2297.28 |
| Anand, Latoya, D,28347 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| James, Isaiah,14630 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yang, Gabriel, W,16724 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cai, Jaclyn,11386 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Brooks, Sebastian,12638 | 38.47 | 0.00 | 0.00 | 0.00 | 38.47 |
| Jenkins, Miranda, L,13387 | 2337.27 | 0.00 | 0.00 | 0.00 | 2337.27 |
| Wang, Ernest,17038 | 2442.28 | 0.00 | 0.00 | 0.00 | 2442.28 |
| Rivera, Richard, L,25998 | 4649.83 | 0.00 | 3399.99 | 0.00 | 1249.84 |
| Zheng, Bianca, G,27662 | 5997.33 | 3578.27 | 0.00 | 0.00 | 2419.06 |
| Russell, Paige,25045 | 38.88 | 0.00 | 0.00 | 38.88 | 0.00 |
| Moreno, Walter, L,20681 | 9.99 | 0.00 | 0.00 | 9.99 | 0.00 |
| Henderson, Alyssa, H,13872 | 180.98 | 0.00 | 0.00 | 180.98 | 0.00 |
| Chande, Dawn, A,15617 | 59.91 | 0.00 | 0.00 | 59.91 | 0.00 |
| Subram, Pamela, M,14167 | 4406.74 | 0.00 | 3578.27 | 0.00 | 828.47 |
| Raman, Troy,21164 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Phillips, Kaitlyn, W,19720 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Thomas, Morgan,12771 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Ross, Alexandra, C,26623 | 2841.44 | 0.00 | 0.00 | 2049.10 | 792.34 |
| Sanders, Dalton,24739 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Brown, John,20637 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Anderson, Nathan,14876 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Patel, Carla,24133 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Wilson, Justin,11842 | 98.97 | 0.00 | 0.00 | 0.00 | 98.97 |
| Kumar, Colleen, R,21912 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Pal, Andres, S,14931 | 6980.85 | 0.00 | 0.00 | 2181.56 | 4799.29 |
| Parker, Luis, S,17768 | 3907.04 | 0.00 | 0.00 | 2181.56 | 1725.48 |
| Wilson, Nicholas, S,23490 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Gao, Darryl,22693 | 1754.98 | 0.00 | 0.00 | 1754.98 | 0.00 |
| James, Cody, A,12176 | 162.28 | 0.00 | 0.00 | 120.00 | 42.28 |
| Bell, Andrea,18775 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Campbell, Mason, V,26989 | 25.48 | 0.00 | 0.00 | 25.48 | 0.00 |
| Russell, Spencer,11302 | 5938.19 | 0.00 | 3578.27 | 2359.92 | 0.00 |
| Gray, Gabriella, M,22276 | 599.47 | 0.00 | 0.00 | 599.47 | 0.00 |
| Stewart, Maria, D,20080 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Wood, Karen,21422 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Davis, Andrew, C,18794 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Lee, Miguel,12749 | 5915.54 | 0.00 | 3578.27 | 0.00 | 2337.27 |
| Jenkins, Zachary,17665 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hill, Jose,18779 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Deng, Nina, O,13790 | 819.48 | 0.00 | 0.00 | 819.48 | 0.00 |
| Alonso, Derrick, W,26017 | 89.46 | 0.00 | 0.00 | 89.46 | 0.00 |
| Jiménez, Alfredo,15430 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Williams, Richard, I,17993 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Parker, Seth, R,18962 | 567.27 | 0.00 | 0.00 | 567.27 | 0.00 |
| Nelson, Chloe, E,12058 | 5936.20 | 0.00 | 3578.27 | 2357.93 | 0.00 |
| Serrano, Lance,23355 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Ward, Grace, S,23356 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Palit, Punya,17574 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Young, Seth, W,17660 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Rubio, Alfredo, D,17929 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Perez, Tabitha, C,22632 | 2492.32 | 0.00 | 0.00 | 0.00 | 2492.32 |
| Collins, Robert,11280 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Rodriguez, Blake,28060 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Baker, Connor,26345 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Cook, Zoe,24616 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Clark, Alexandra, R,23271 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Williams, Dalton, A,17602 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Goel, Maurice,11410 | 4464.07 | 0.00 | 0.00 | 4464.07 | 0.00 |
| James, Abigail,24497 | 71.58 | 0.00 | 0.00 | 71.58 | 0.00 |
| Jackson, Isabella, L,22038 | 84.95 | 0.00 | 0.00 | 84.95 | 0.00 |
| Lewis, Sydney, L,17447 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Xu, Todd,28456 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Anand, Terrence, J,16204 | 7162.39 | 0.00 | 0.00 | 2443.35 | 4719.04 |
| Hayes, Jonathan,26854 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Moreno, Audrey,14802 | 3287.32 | 0.00 | 0.00 | 2443.35 | 843.97 |
| Tang, Misty, A,14248 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Bell, Cody, A,12965 | 56.97 | 0.00 | 0.00 | 56.97 | 0.00 |
| Richardson, Bryce,11169 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Martinez, Jillian,24529 | 2398.05 | 0.00 | 0.00 | 2398.05 | 0.00 |
| Brooks, Julia, W,11949 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chande, Misty,21059 | 616.95 | 0.00 | 0.00 | 616.95 | 0.00 |
| Vazquez, Tabitha, E,19821 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Serrano, Eddie,21041 | 589.96 | 0.00 | 0.00 | 589.96 | 0.00 |
| Brown, Megan, S,15844 | 3134.95 | 0.00 | 0.00 | 782.99 | 2351.96 |
| Yuan, Priscilla, L,17107 | 4179.33 | 0.00 | 0.00 | 4179.33 | 0.00 |
| Walker, Victoria, E,15768 | 3124.96 | 0.00 | 0.00 | 782.99 | 2341.97 |
| Sanders, Brooke,11198 | 98.47 | 0.00 | 0.00 | 98.47 | 0.00 |
| Mehta, Holly, L,12180 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Powell, Connor, M,25839 | 107.94 | 0.00 | 0.00 | 107.94 | 0.00 |
| Powell, Alexandria,22733 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Ma, Aimee, R,21868 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Jenkins, Destiny, G,17521 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Perez, Kristopher, E,29428 | 47.96 | 0.00 | 0.00 | 47.96 | 0.00 |
| Perry, Katherine, S,12386 | 4447.37 | 0.00 | 0.00 | 2071.42 | 2375.95 |
| Liang, Edwin, W,12327 | 13.98 | 0.00 | 0.00 | 8.99 | 4.99 |
| Jenkins, Maria, L,12068 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
| Russell, Mariah,13882 | 3282.81 | 0.00 | 0.00 | 3282.81 | 0.00 |
| Nara, Ashlee, A,16049 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Anderson, Zachary,11324 | 5945.23 | 0.00 | 3578.27 | 2366.96 | 0.00 |
| She, Tasha,15680 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Blanco, Lawrence, W,11189 | 5944.22 | 0.00 | 3578.27 | 2365.95 | 0.00 |
| Yang, Alisha,16266 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Torres, Jasmine, A,11216 | 5948.24 | 0.00 | 3578.27 | 2369.97 | 0.00 |
| Phillips, Dalton,23159 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Parker, Xavier, M,24669 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Edwards, Fernando,23185 | 638.95 | 0.00 | 0.00 | 0.00 | 638.95 |
| Malhotra, Manuel, S,21602 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Romero, Arthur,12712 | 4441.06 | 0.00 | 0.00 | 2049.10 | 2391.96 |
| Ma, Colleen, A,11480 | 4935.36 | 0.00 | 0.00 | 4381.39 | 553.97 |
| Jenkins, Miguel, R,25166 | 134.56 | 0.00 | 0.00 | 0.00 | 134.56 |
| Jimenez, Jaime, J,28333 | 53.99 | 0.00 | 0.00 | 53.99 | 0.00 |
| Long, David, V,29205 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Simmons, Emma, L,13940 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Hughes, Kevin, A,25354 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Nara, Peter, T,11770 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Murphy, Rachel, A,23686 | 94.46 | 0.00 | 0.00 | 0.00 | 94.46 |
| Liang, Connie, R,19740 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Johnson, Taylor, H,16047 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cox, Richard,17440 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rana, Pamela, L,17446 | 2384.96 | 0.00 | 0.00 | 0.00 | 2384.96 |
| Gao, Heather,19061 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Zhu, Dennis, E,12966 | 106.96 | 0.00 | 0.00 | 0.00 | 106.96 |
| Nath, Priscilla, H,21820 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Bebbington, Mark, E,26012 | 5794.05 | 0.00 | 3374.99 | 0.00 | 2419.06 |
| Raman, Ross,22529 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sanchez, Andrea, L,22787 | 620.46 | 0.00 | 0.00 | 0.00 | 620.46 |
| Hernandez, Hector, E,27608 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Martin, Elizabeth, L,19649 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Bailey, Timothy, L,18456 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Reed, Chloe,15258 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ma, Glenn, M,16280 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Ruiz, Roberto,15918 | 3149.95 | 0.00 | 0.00 | 782.99 | 2366.96 |
Generated 2025-11-04 03:25:17.692 UTC