[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 846 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Guo, Amy, A,15301 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Morris, Maria, K,16254 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Yuan, Tara, G,22795 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Guo, Arturo, K,20941 | 126.28 | 0.00 | 0.00 | 0.00 | 126.28 |
| Tang, Maurice, M,11160 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Peterson, Taylor, P,26315 | 2825.43 | 0.00 | 0.00 | 2049.10 | 776.33 |
| Jai, Colin,12138 | 119.91 | 0.00 | 0.00 | 0.00 | 119.91 |
| Weisman, Charles,26511 | 4464.48 | 0.00 | 0.00 | 2071.42 | 2393.06 |
| Coleman, Anna,26338 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Gonzalez, Haley, J,20706 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
| Dominguez, Ricky, B,25658 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Prasad, Nancy,24709 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Hughes, Jordan,26244 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Jenkins, Oscar, A,24416 | 96.07 | 0.00 | 0.00 | 0.00 | 96.07 |
| Bennett, Alexis,21786 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 |
| Kelly, Kimberly,18402 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Travers, Sydney,19656 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Li, Clarence, M,23609 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Kelly, Chase, E,11743 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Scott, Wyatt,23039 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Zheng, Margaret, D,13823 | 5393.31 | 0.00 | 0.00 | 2443.35 | 2949.96 |
| Washington, Jonathan, A,20761 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Li, Cameron,25902 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Torres, Frank, M,16582 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Griffin, Jocelyn,23623 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Young, Caleb, C,23237 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Foster, Angelica,12791 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Suarez, Latasha,11471 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Morgan, Danielle,19164 | 629.96 | 0.00 | 0.00 | 0.00 | 629.96 |
| Nara, Alejandro, S,19364 | 3613.81 | 0.00 | 0.00 | 0.00 | 3613.81 |
| Lee, Jeremiah,28128 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Lin, Alisha,19385 | 116.95 | 0.00 | 0.00 | 0.00 | 116.95 |
| Alexander, Brianna,14503 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramos, Mallory, M,18878 | 2390.95 | 0.00 | 0.00 | 0.00 | 2390.95 |
| Foster, Dalton, E,18378 | 2439.99 | 0.00 | 0.00 | 0.00 | 2439.99 |
| Garcia, David,22683 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Diaz, Pedro, J,12954 | 51.27 | 0.00 | 0.00 | 0.00 | 51.27 |
| Lin, Arturo,13439 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Moore, Gail,21941 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Jimenez, Ruben, A,20895 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Morgan, Grace, E,25601 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Hu, Shannon,19438 | 4337.90 | 0.00 | 699.10 | 0.00 | 3638.80 |
| Xu, Franklin, C,19439 | 4349.89 | 0.00 | 699.10 | 0.00 | 3650.79 |
| Hernandez, Jerome,16270 | 2771.52 | 0.00 | 0.00 | 2181.56 | 589.96 |
| Collins, Ian,25904 | 89.46 | 0.00 | 0.00 | 0.00 | 89.46 |
| Sharma, Tamara,11655 | 50.23 | 0.00 | 0.00 | 0.00 | 50.23 |
| Raje, Willie, C,12641 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Rubio, Marc, I,27854 | 750.30 | 0.00 | 0.00 | 0.00 | 750.30 |
| Long, Mya, O,28191 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Prasad, Ann, D,24333 | 616.95 | 0.00 | 0.00 | 0.00 | 616.95 |
| Gonzalez, Kristi, A,13734 | 4522.50 | 0.00 | 0.00 | 2181.56 | 2340.94 |
| Munoz, Larry,11242 | 11068.01 | 0.00 | 0.00 | 4369.09 | 6698.92 |
| Cook, Kimberly, R,28190 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Stewart, Sean,23886 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Watson, Chloe, O,19293 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Ross, Stephanie,29211 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| James, Isabella, R,17132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Coleman, Aaron,16749 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Sandberg, Clinton, S,21009 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mitchell, Jada,11851 | 84.99 | 0.00 | 0.00 | 0.00 | 84.99 |
| Alexander, Robert,14025 | 1586.38 | 0.00 | 1000.44 | 0.00 | 585.94 |
| Collins, Sydney, V,13733 | 4553.52 | 0.00 | 0.00 | 2181.56 | 2371.96 |
| Foster, Taylor, F,18611 | 2391.94 | 0.00 | 0.00 | 0.00 | 2391.94 |
| Sanders, Evan, C,15506 | 1552.48 | 0.00 | 0.00 | 782.99 | 769.49 |
| Wright, Janet, E,24323 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Griffin, Elizabeth, L,22137 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Smith, Kari, A,14164 | 6484.71 | 0.00 | 3578.27 | 0.00 | 2906.44 |
| Gonzales, Connor, M,16923 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Smith, Marcus, R,15835 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Cook, Jasmine, C,14408 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 |
| Martinez, Ashley,11166 | 87.96 | 0.00 | 0.00 | 0.00 | 87.96 |
| Torres, Alex, L,18512 | 2349.98 | 0.00 | 0.00 | 0.00 | 2349.98 |
| Howard, Xavier, D,18395 | 2374.98 | 0.00 | 0.00 | 0.00 | 2374.98 |
| Jackson, Zachary,26681 | 2813.77 | 0.00 | 0.00 | 2071.42 | 742.35 |
| Bennett, Aidan,18998 | 1784.96 | 0.00 | 0.00 | 0.00 | 1784.96 |
| Zheng, Cedric, V,18803 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Perry, Blake, D,24260 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Scott, Xavier,14764 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zhu, Leah,22474 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Romero, Anne,18514 | 2389.96 | 0.00 | 0.00 | 0.00 | 2389.96 |
| Stewart, Riley, L,18420 | 2414.99 | 0.00 | 0.00 | 0.00 | 2414.99 |
| Peterson, Jasmine, R,26298 | 3340.26 | 0.00 | 0.00 | 2071.42 | 1268.84 |
| Patterson, Katherine, E,28154 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Wood, Chloe, L,23878 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| King, Marcus,22152 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 |
| Prasad, Manuel,26984 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Sai, Ebony, C,16259 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Anderson, Marcus,12963 | 108.46 | 0.00 | 0.00 | 0.00 | 108.46 |
| Ross, Kevin, L,18993 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Nara, Kenneth, K,14177 | 46.83 | 0.00 | 0.00 | 0.00 | 46.83 |
| James, Caitlin, V,15503 | 1622.45 | 0.00 | 0.00 | 782.99 | 839.46 |
| Prasad, Toni,27900 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Deng, Dawn, L,16439 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Patterson, Alexandra, A,19489 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Hernandez, Kyle, A,19401 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Coleman, Xavier, A,27630 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Perry, Sarah, M,19407 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Carlson, Kristi,21055 | 1566.78 | 0.00 | 0.00 | 0.00 | 1566.78 |
| Cai, Heather,27128 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Carlson, Victor,14425 | 8332.30 | 0.00 | 3578.27 | 0.00 | 4754.03 |
| Robinson, Alexander, J,15737 | 3117.23 | 0.00 | 0.00 | 782.99 | 2334.24 |
| Perry, Jason, M,24325 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Gonzalez, Janelle, S,16007 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Stewart, Bryce, B,14562 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lopez, Evan,22245 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Perez, Mary,26610 | 4509.48 | 0.00 | 0.00 | 2071.42 | 2438.06 |
| Baker, Sierra,19465 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jenkins, Julia, R,19156 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Brown, Seth, A,14731 | 2435.08 | 0.00 | 699.10 | 0.00 | 1735.98 |
| Zeng, Eugene,24025 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Campbell, Samuel,18109 | 123.48 | 0.00 | 0.00 | 0.00 | 123.48 |
| Murphy, Xavier,29162 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Patterson, Brittany, M,12982 | 57.97 | 0.00 | 0.00 | 0.00 | 57.97 |
| Moore, Brandon, T,29218 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Vazquez, Walter, D,28412 | 45.58 | 0.00 | 0.00 | 0.00 | 45.58 |
| Suri, Cindy,18989 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Navarro, Gloria, M,21537 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Anand, Sheena, L,14907 | 127.28 | 0.00 | 0.00 | 0.00 | 127.28 |
| Butler, Emily, M,20964 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rodriguez, Emma, H,13191 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Raji, Rafael, C,25619 | 1273.83 | 0.00 | 0.00 | 0.00 | 1273.83 |
| Zeng, Alejandro, J,18171 | 3319.40 | 0.00 | 0.00 | 1000.44 | 2318.96 |
| Bryant, Eric,13471 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Zhang, Dylan, L,27321 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
Generated 2025-12-24 06:35:34.118 UTC