[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Harris, Robert, A,14075 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Veronesi, Giorgio,24346 | 2473.04 | 0.00 | 0.00 | 0.00 | 2473.04 |
| Jenkins, Taylor,22791 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Blanco, Felicia,12297 | 8022.58 | 0.00 | 0.00 | 2049.10 | 5973.48 |
| Lan, Andrew, L,28011 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Parker, Thomas,27399 | 84.46 | 0.00 | 0.00 | 0.00 | 84.46 |
| Luo, Kelli,23946 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Wang, Robert, B,13236 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Shen, Ashlee, C,16566 | 5806.35 | 0.00 | 0.00 | 2181.56 | 3624.79 |
| Adams, Lucas,18559 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Liu, Valerie, R,24121 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Lopez, Jeremiah,26297 | 3286.92 | 0.00 | 2049.10 | 0.00 | 1237.82 |
| Chen, Sandra,13811 | 3001.04 | 0.00 | 2181.56 | 0.00 | 819.48 |
| Garcia, Jose, L,13425 | 4810.31 | 0.00 | 2443.35 | 0.00 | 2366.96 |
| Baker, Stephanie, S,15287 | 1681.45 | 0.00 | 782.99 | 0.00 | 898.46 |
| Thomas, Julia, B,13400 | 4568.50 | 0.00 | 2181.56 | 0.00 | 2386.94 |
| Liang, Susan,28520 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
| White, Eduardo, F,15626 | 7029.07 | 0.00 | 2181.56 | 0.00 | 4847.51 |
| Rodriguez, Seth,14203 | 7081.46 | 0.00 | 2181.56 | 0.00 | 4899.90 |
| Patterson, Haley,15303 | 3077.98 | 0.00 | 782.99 | 0.00 | 2294.99 |
| Raman, Stefanie,14424 | 6998.86 | 0.00 | 2181.56 | 0.00 | 4817.30 |
| Brown, Katherine,14538 | 3017.01 | 0.00 | 2181.56 | 0.00 | 835.45 |
| Xu, Mitchell, J,12218 | 4472.37 | 0.00 | 0.00 | 2071.42 | 2400.95 |
| Thompson, Brandon, J,15311 | 1622.47 | 0.00 | 782.99 | 0.00 | 839.48 |
| Alonso, Jay, A,15675 | 7206.38 | 0.00 | 2443.35 | 0.00 | 4763.03 |
| White, Jasmine,13443 | 4536.54 | 0.00 | 2181.56 | 0.00 | 2354.98 |
| Lopez, Alexandra,14088 | 2755.42 | 0.00 | 1000.44 | 0.00 | 1754.98 |
| Griffin, Gail,13436 | 4498.53 | 0.00 | 2181.56 | 0.00 | 2316.97 |
| Washington, Trevor,26326 | 4442.16 | 0.00 | 2049.10 | 0.00 | 2393.06 |
| Griffin, Abigail, A,19256 | 2518.97 | 0.00 | 782.99 | 0.00 | 1735.98 |
| Raheem, Tommy, A,15674 | 3053.32 | 0.00 | 2443.35 | 0.00 | 609.97 |
| James, Bryan, E,13431 | 4592.50 | 0.00 | 2181.56 | 0.00 | 2410.94 |
| Martinez, Phillip, G,28562 | 3219.19 | 0.00 | 2071.42 | 0.00 | 1147.77 |
| Vazquez, Paula,13442 | 4500.82 | 0.00 | 2181.56 | 0.00 | 2319.26 |
| Garcia, Cesar, L,19194 | 1589.75 | 0.00 | 782.99 | 0.00 | 806.76 |
| Brooks, Eduardo, F,15320 | 3152.96 | 0.00 | 782.99 | 0.00 | 2369.97 |
| Torres, Amanda, T,14036 | 1839.92 | 0.00 | 1000.44 | 0.00 | 839.48 |
| Wood, Elizabeth, D,26312 | 2881.74 | 0.00 | 2071.42 | 810.32 | 0.00 |
| Xie, Terrence,16199 | 6917.59 | 0.00 | 2181.56 | 0.00 | 4736.03 |
| Kapoor, Ronald,14192 | 9451.91 | 0.00 | 2181.56 | 0.00 | 7270.35 |
| Howard, Katelyn, L,19174 | 2483.98 | 0.00 | 782.99 | 0.00 | 1700.99 |
| Williams, Anthony, V,29250 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Long, Luis, F,24318 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Weisman, Daniel, J,17616 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanchez, Mayra, S,26882 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Collins, Timothy, R,24990 | 2468.04 | 0.00 | 0.00 | 0.00 | 2468.04 |
| Prasad, Brenda, E,22506 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| She, Brad,12307 | 9594.92 | 0.00 | 0.00 | 2443.35 | 7151.57 |
| Cook, Chase, L,25336 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Richardson, Jessica, S,20184 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Munoz, Janet,11439 | 12489.17 | 0.00 | 0.00 | 10070.11 | 2419.06 |
| Schmidt, Stanley, C,19035 | 3320.43 | 0.00 | 0.00 | 1000.44 | 2319.99 |
| Cook, Chloe, L,26790 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Powell, Dalton, C,21697 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Russell, Alexia,19742 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Bennett, Gabrielle,20467 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 |
| Raje, Colin,26378 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Campbell, Jack,24150 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Mr., Saddow, Peter,24075 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Russell, Amanda,14094 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Bell, Abigail,13914 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Jenkins, Edward, S,28725 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
Generated 2025-11-06 22:13:12.364 UTC