[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Torres, Erik, J,14919 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Davis, Alyssa, C,13243 | 4511.54 | 0.00 | 2181.56 | 0.00 | 2329.98 |
| Griffin, Dakota,13283 | 4498.53 | 0.00 | 2181.56 | 0.00 | 2316.97 |
| Williams, John, C,13238 | 4511.54 | 0.00 | 2181.56 | 0.00 | 2329.98 |
| Chen, Noah, L,26290 | 3295.26 | 0.00 | 2071.42 | 0.00 | 1223.84 |
| Zhao, Darryl,15656 | 2992.33 | 0.00 | 2443.35 | 0.00 | 548.98 |
| Coleman, Lauren,13419 | 4476.55 | 0.00 | 2181.56 | 0.00 | 2294.99 |
| Munoz, Joanna,13812 | 3262.83 | 0.00 | 2443.35 | 0.00 | 819.48 |
| Lee, Taylor,14022 | 1668.90 | 0.00 | 1000.44 | 0.00 | 668.46 |
| Rodriguez, Brandon, K,13287 | 4763.34 | 0.00 | 2443.35 | 0.00 | 2319.99 |
| Chen, Zachary,13247 | 4548.52 | 0.00 | 2181.56 | 0.00 | 2366.96 |
| Hayes, Kayla,26285 | 3309.24 | 0.00 | 2071.42 | 0.00 | 1237.82 |
| Rivera, Angela, J,15659 | 3047.81 | 0.00 | 2443.35 | 0.00 | 604.46 |
| Kapoor, Toni, K,26295 | 3298.94 | 0.00 | 2049.10 | 0.00 | 1249.84 |
| Bryant, Ana,14141 | 3282.81 | 0.00 | 2443.35 | 0.00 | 839.46 |
| Shan, Dustin,23965 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Carter, Charles, R,22899 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Hu, Randy,14976 | 7040.61 | 0.00 | 0.00 | 2181.56 | 4859.05 |
| Shen, Tonya,18004 | 819.48 | 0.00 | 0.00 | 0.00 | 819.48 |
| Gomez, Deanna,15655 | 2753.82 | 0.00 | 2181.56 | 0.00 | 572.26 |
| 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 |
| She, Franklin,24530 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Torres, Evan,19543 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Chander, Franklin, E,18006 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Zhang, Jorge,26874 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Ward, Sean,25059 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
| 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 |
| Cooper, Chase,27194 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Arun, Manuel,26697 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Henderson, Zachary,23512 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Hayes, Dylan, O,17455 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Washington, Hunter,17695 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Parker, Logan, A,12306 | 74.97 | 0.00 | 0.00 | 0.00 | 74.97 |
| Reed, Caitlin, A,13344 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Martinez, Samuel, J,19141 | 579.97 | 0.00 | 0.00 | 0.00 | 579.97 |
Generated 2025-11-07 03:30:53.593 UTC