[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 958 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Tang, Kate,20036 | 2618.62 | 0.00 | 0.00 | 2618.62 | 0.00 |
| Campbell, Luis, A,19170 | 1151.76 | 0.00 | 0.00 | 1151.76 | 0.00 |
| Brooks, Melissa,19198 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Torres, Maria,16792 | 1735.98 | 0.00 | 0.00 | 1735.98 | 0.00 |
| Rodriguez, Patricia, M,22273 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Suri, Sergio, C,16391 | 4624.91 | 0.00 | 0.00 | 4624.91 | 0.00 |
| Becker, Katie, F,26997 | 1149.47 | 0.00 | 0.00 | 0.00 | 1149.47 |
| Collins, Bailey,11970 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Jones, Marcus, J,11717 | 192.47 | 0.00 | 0.00 | 0.00 | 192.47 |
| Alexander, Jocelyn,11165 | 102.49 | 0.00 | 0.00 | 0.00 | 102.49 |
| Diaz, Anna,24803 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Luo, Sheena, A,20733 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Nicholls, Melody,27327 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Xu, Nina,13291 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Baker, Courtney, A,18988 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Richardson, Jade, R,19540 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Turner, Maria, E,14548 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Moreno, Michele, P,27824 | 786.33 | 0.00 | 0.00 | 0.00 | 786.33 |
| Garcia, Jose, L,13425 | 4810.31 | 0.00 | 2443.35 | 0.00 | 2366.96 |
| Munoz, Robin, E,27897 | 750.30 | 0.00 | 0.00 | 0.00 | 750.30 |
| Zhou, Jorge, M,22319 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Nara, Andres, A,12332 | 7211.26 | 0.00 | 0.00 | 0.00 | 7211.26 |
| Lal, Kevin,27564 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Bell, Isaiah, W,27197 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Vazquez, Nelson, D,22076 | 65.95 | 0.00 | 0.00 | 0.00 | 65.95 |
| Mitchell, Jesse, C,15776 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Goel, Kristin, L,25473 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Johnson, Nathan, J,11178 | 144.76 | 0.00 | 0.00 | 102.48 | 42.28 |
| Powell, Faith, O,23509 | 575.71 | 0.00 | 0.00 | 0.00 | 575.71 |
| Sharma, Connor, M,23505 | 616.95 | 0.00 | 0.00 | 0.00 | 616.95 |
| Anand, Casey, F,25522 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Jiménez, Danny,16252 | 2781.54 | 0.00 | 0.00 | 2181.56 | 599.98 |
| Richardson, Jared, C,23579 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Ramirez, Stephanie, E,12758 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Henderson, Adam,17040 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Lewis, Ashley, L,12960 | 51.27 | 0.00 | 0.00 | 0.00 | 51.27 |
| Yang, Benjamin,27219 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Carter, Noah, E,25954 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Parker, Jose, B,21713 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Chandra, Darren,20698 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Simmons, Emma, L,13940 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Henderson, Angelica, M,16006 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Kapoor, Henry, C,20715 | 196.27 | 0.00 | 0.00 | 0.00 | 196.27 |
| Raman, Toni,21530 | 128.95 | 0.00 | 0.00 | 0.00 | 128.95 |
| Peterson, Jade, J,14587 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Watson, Kaitlyn, R,15246 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| She, Calvin, A,18154 | 66.44 | 0.00 | 0.00 | 0.00 | 66.44 |
| Liang, Connie, R,19740 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Clark, Fernando, C,14872 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Sr., Alonso, Jésus, V,20841 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Jackson, Tyler, L,17042 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Mitchell, Kaitlyn, D,18130 | 5743.97 | 0.00 | 1000.44 | 0.00 | 4743.53 |
| Yuan, Mindy, D,12201 | 58.18 | 0.00 | 0.00 | 0.00 | 58.18 |
| Carter, Thomas, W,22792 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Davis, Alyssa, C,13243 | 4511.54 | 0.00 | 2181.56 | 0.00 | 2329.98 |
| Hall, Bailey, C,19528 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
Generated 2024-11-11 05:13:34.427 UTC