[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 958 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Gutierrez, Arthur, A,12504 | 61.08 | 0.00 | 0.00 | 0.00 | 61.08 |
| Romero, Kristine, W,16306 | 29.26 | 0.00 | 0.00 | 0.00 | 29.26 |
| Alonso, Larry, B,13586 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Rivera, Seth,17879 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Lopez, Marie,16192 | 101.45 | 0.00 | 0.00 | 29.48 | 71.97 |
| Shen, Bethany, C,17903 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Gao, Jessie,20564 | 3059.08 | 0.00 | 699.10 | 0.00 | 2359.98 |
| Jimenez, Rodney, R,12476 | 73.77 | 0.00 | 0.00 | 0.00 | 73.77 |
| Gutierrez, Teresa, A,15083 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Dominguez, Jésus,17087 | 75.21 | 0.00 | 0.00 | 0.00 | 75.21 |
| Anand, Nicolas, P,20567 | 3074.08 | 0.00 | 699.10 | 0.00 | 2374.98 |
| Carlson, Jerome, J,21817 | 791.47 | 0.00 | 0.00 | 0.00 | 791.47 |
| Richardson, Megan, M,15662 | 5253.07 | 0.00 | 3578.27 | 0.00 | 1674.80 |
| Sutton, Marshall,20862 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Cai, Stacey,20575 | 3095.04 | 0.00 | 699.10 | 0.00 | 2395.94 |
| Green, Morgan, M,28469 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Luo, Calvin, T,19172 | 1609.41 | 0.00 | 1000.44 | 0.00 | 608.97 |
| Guo, Kelvin, H,17705 | 37.26 | 0.00 | 0.00 | 29.98 | 7.28 |
| Gomez, Robyn,16046 | 3963.14 | 0.00 | 2443.35 | 0.00 | 1519.79 |
| Sun, Trisha,22442 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Sara, Evelyn,16045 | 3802.37 | 0.00 | 2181.56 | 0.00 | 1620.81 |
| Zhou, Lisa, L,13809 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Goel, Louis,24055 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Alvarez, Micheal, W,13495 | 57.95 | 0.00 | 0.00 | 0.00 | 57.95 |
| Vazquez, Jaime,22304 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Hu, Vincent, F,28372 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Ray, Harold, A,13516 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Patel, Stefanie,27967 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
Generated 2024-11-11 05:06:59.363 UTC