[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wright, Sydney, S,25863 | 4631.11 | 3399.99 | 0.00 | 0.00 | 1231.12 |
| Brown, Edward,27621 | 5971.33 | 3578.27 | 0.00 | 0.00 | 2393.06 |
| Edwards, Courtney, A,27606 | 5997.33 | 3578.27 | 0.00 | 0.00 | 2419.06 |
| Hill, Lucas,27612 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Bailey, Jesse, A,18061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Howard, Faith,13656 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Huang, Kelvin,14560 | 1538.58 | 699.10 | 0.00 | 0.00 | 839.48 |
| Gray, Cole,27658 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Torres, Carrie,25372 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Nath, Tracy, B,16507 | 35.23 | 0.00 | 0.00 | 0.00 | 35.23 |
| Carlson, Rebekah,29377 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Green, Carlos,18387 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanders, Cole,23969 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Bailey, Evan, C,27649 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Sanchez, Jessica, M,27667 | 5997.33 | 3578.27 | 0.00 | 0.00 | 2419.06 |
| Scott, Jackson,13759 | 100.46 | 0.00 | 0.00 | 0.00 | 100.46 |
| Yuan, Donna, D,29434 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Sanchez, Dalton, C,15986 | 1422.94 | 0.00 | 0.00 | 782.99 | 639.95 |
| Alexander, Miranda,27641 | 5962.34 | 3578.27 | 0.00 | 0.00 | 2384.07 |
| Price, Angela, D,19714 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Taylor, Justin, G,28066 | 5997.33 | 3578.27 | 0.00 | 0.00 | 2419.06 |
| Foster, Rachel,28018 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Gomez, Philip,28038 | 5985.31 | 3578.27 | 0.00 | 0.00 | 2407.04 |
| Brown, Brandon, E,14400 | 3357.40 | 0.00 | 0.00 | 1000.44 | 2356.96 |
| Bennett, Cassidy, A,16951 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Mitchell, Jack, L,28040 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Gonzalez, Jason,28030 | 5971.33 | 3578.27 | 0.00 | 0.00 | 2393.06 |
| Murphy, Jesse,11040 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Ross, Samantha, R,27918 | 5998.61 | 3578.27 | 0.00 | 0.00 | 2420.34 |
| Walker, Natalie,12894 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Foster, Melanie,14572 | 3016.07 | 699.10 | 0.00 | 0.00 | 2316.97 |
| Cai, Lisa,11241 | 11469.19 | 0.00 | 0.00 | 4379.08 | 7090.11 |
| Simmons, Brianna, E,25878 | 4649.83 | 3399.99 | 0.00 | 0.00 | 1249.84 |
| Romero, Victor, C,12211 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Mehta, Francisco, K,17982 | 839.46 | 0.00 | 0.00 | 0.00 | 839.46 |
| Jones, Brandon, C,28145 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Ward, Jacqueline,28168 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Alexander, Eric, S,28185 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Cox, Alexa,20505 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Patterson, James, P,26583 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Stewart, Nicole, A,20129 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Hayes, Alexandria, C,27474 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Lewis, Jacob, K,18799 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Perry, Noah, K,26679 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Barnes, Jennifer, A,28097 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Coleman, Tristan,15883 | 89.95 | 0.00 | 0.00 | 0.00 | 89.95 |
| Alan, Xavier,15384 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Stewart, Alexandra, S,28096 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Chen, Connor, M,28150 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Jones, William,17342 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Patterson, Katherine, E,28154 | 5971.33 | 3578.27 | 0.00 | 0.00 | 2393.06 |
| Rai, Keith, W,16396 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Chander, Jerry, M,28180 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Long, Mya, O,28191 | 5997.33 | 3578.27 | 0.00 | 0.00 | 2419.06 |
| Lin, Willie, B,28142 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Garcia, Lydia, P,28194 | 6114.81 | 3578.27 | 0.00 | 0.00 | 2536.54 |
| Foster, Vanessa,16372 | 2482.23 | 0.00 | 0.00 | 0.00 | 2482.23 |
| Harris, Alexandra,12764 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Russell, Wyatt, A,28598 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Jones, Alyssa, M,28199 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Richardson, Jesse, M,25895 | 4649.83 | 0.00 | 3399.99 | 0.00 | 1249.84 |
| Baker, Blake,25368 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 |
Generated 2025-11-03 15:37:25.277 UTC