[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Russell, Edward,24642 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Travers, Sydney,19656 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Zhao, Willie,11392 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Simmons, Blake,12951 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Price, Richard,21791 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Sara, Cindy, M,14930 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Garcia, Whitney, H,24944 | 125.57 | 0.00 | 0.00 | 0.00 | 125.57 |
| Xu, Brittney, E,26688 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Jones, Olivia, A,21307 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Beck, Ralph,12838 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Brooks, Jasmine, S,19252 | 94.97 | 0.00 | 0.00 | 0.00 | 94.97 |
| Deng, Dawn, L,16439 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Serrano, Casey, O,28887 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Morris, Patrick, E,25688 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| James, Ian, A,15899 | 3133.95 | 0.00 | 0.00 | 782.99 | 2350.96 |
| Patterson, Brittany, M,12982 | 57.97 | 0.00 | 0.00 | 0.00 | 57.97 |
| Kovár, Andre, S,20731 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Wood, Victoria, V,12896 | 44.91 | 0.00 | 0.00 | 0.00 | 44.91 |
| Henderson, Caleb,22885 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Carson, Russell, J,20062 | 1997.45 | 0.00 | 782.99 | 0.00 | 1214.46 |
| Hayes, Julian,15745 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Serrano, Ruben, L,23916 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| He, Brittney,20810 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Rogers, Garrett,15739 | 3140.27 | 0.00 | 0.00 | 782.99 | 2357.28 |
| Ross, Alexis, L,15983 | 3134.95 | 0.00 | 0.00 | 782.99 | 2351.96 |
| Rubio, Julio,17945 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Shan, Nathan, C,27999 | 102.96 | 0.00 | 0.00 | 0.00 | 102.96 |
| Scott, Caleb,24936 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Martinez, Tammy, R,20927 | 101.94 | 0.00 | 0.00 | 0.00 | 101.94 |
| She, Shaun,28445 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Hernandez, Noah,16967 | 2316.97 | 0.00 | 0.00 | 0.00 | 2316.97 |
| Martin, Theodore, W,21588 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Gonzales, Taylor, M,21590 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Watson, Lucas,16992 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cai, Jon,23773 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Xu, Sandra, A,16976 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Evans, Alex, C,12365 | 53.97 | 0.00 | 0.00 | 0.00 | 53.97 |
| Howard, Dalton,25260 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Carlson, Mallory, A,19281 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Scott, Samuel, C,23161 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Simmons, Samantha, V,29232 | 173.47 | 0.00 | 0.00 | 0.00 | 173.47 |
| Walker, Edward, D,28090 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bryant, Hunter,26259 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Roberts, Lucas,21802 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Roberts, Kevin, A,20705 | 69.47 | 0.00 | 0.00 | 0.00 | 69.47 |
| Sharma, Gabriel,15618 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Liu, Jeffery, M,17788 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Miller, Logan, H,22896 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Munoz, Paula, M,22066 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Brooks, Danielle,19999 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Shen, Johnny,19330 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Rana, Bruce, E,21125 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Yuan, Corey,27334 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Butler, Maria,16067 | 664.89 | 0.00 | 0.00 | 0.00 | 664.89 |
| Hughes, Aaron, J,26694 | 4456.14 | 0.00 | 0.00 | 2049.10 | 2407.04 |
| Reed, Carlos, E,21750 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Perry, Carol,21510 | 128.95 | 0.00 | 0.00 | 0.00 | 128.95 |
| Zeng, Mandy,25630 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Blanco, Julio, J,17678 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Gao, Colin,18108 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Sanz, Adrienne,16298 | 7000.87 | 0.00 | 0.00 | 2181.56 | 4819.31 |
| Wilson, Lucas,27622 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
Generated 2025-11-06 19:34:30.310 UTC