[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rai, Kara, D,26970 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Munoz, Roberto,17628 | 106.24 | 0.00 | 0.00 | 0.00 | 106.24 |
| He, Alisha, R,18026 | 2988.32 | 0.00 | 0.00 | 2181.56 | 806.76 |
| Yuan, Cedric,15449 | 49.56 | 0.00 | 0.00 | 0.00 | 49.56 |
| Li, Steve,21137 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Harrison, Melody,28468 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sharma, Katie,21106 | 2537.97 | 0.00 | 0.00 | 782.99 | 1754.98 |
| Lin, Erica, E,16033 | 3743.39 | 0.00 | 2181.56 | 0.00 | 1561.83 |
| Madan, Donald, R,27168 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Gill, Krista,12664 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Malhotra, Raymond, T,13251 | 6844.42 | 0.00 | 0.00 | 2049.10 | 4795.32 |
| Vance, Regina, M,14984 | 6699.57 | 0.00 | 3578.27 | 0.00 | 3121.30 |
| Guo, Alvin, R,28878 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Johnsen, Rebekah, J,19919 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xie, Carly, R,13253 | 6774.45 | 0.00 | 0.00 | 2071.42 | 4703.03 |
| Gonzalez, Cassandra,17967 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Chen, Gilbert, E,27906 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Rai, Sheena,29393 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| He, Franklin, K,18127 | 6982.07 | 0.00 | 0.00 | 2181.56 | 4800.51 |
| Shen, Jaime,13765 | 7152.09 | 0.00 | 3578.27 | 0.00 | 3573.82 |
| Phillips, Nathan,25537 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raji, Colin, A,25801 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Black, Shawn, A,19499 | 3492.76 | 0.00 | 0.00 | 3492.76 | 0.00 |
| Gonzalez, Troy, A,28517 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Lopez, Raymond, G,27317 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ma, Stacey,21840 | 31.27 | 0.00 | 0.00 | 31.27 | 0.00 |
| Zheng, Jessie, W,18028 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Deng, Brad, D,20042 | 3150.40 | 699.10 | 0.00 | 0.00 | 2451.30 |
| Carlson, Jerome, J,21817 | 791.47 | 0.00 | 0.00 | 0.00 | 791.47 |
| Robinson, Nicole,28730 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Prasad, Cassandra, D,18621 | 3033.33 | 0.00 | 0.00 | 2443.35 | 589.98 |
| Sai, Phillip, M,13563 | 5948.23 | 3578.27 | 0.00 | 0.00 | 2369.96 |
| Raji, Tracy,22439 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Luo, Alvin,23635 | 2452.34 | 0.00 | 0.00 | 2452.34 | 0.00 |
| Rodriguez, Jessica,21669 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Lal, Tamara,13576 | 8330.79 | 3578.27 | 0.00 | 0.00 | 4752.52 |
| Martinez, Donald, D,25482 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Ma, Randy, R,24550 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Li, Suzanne,21508 | 3152.95 | 0.00 | 0.00 | 782.99 | 2369.96 |
| Goel, Latoya, C,11239 | 7511.55 | 3374.99 | 0.00 | 2353.95 | 1782.61 |
| Washington, Anna,14817 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Sanchez, Preston, J,12506 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Alonso, Joy, A,19918 | 3360.41 | 0.00 | 0.00 | 1000.44 | 2359.97 |
| Chavez, Colleen, H,20049 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Torres, Janet, J,23985 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wu, Ramon, M,27955 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Blanco, Jacquelyn,13411 | 6819.46 | 0.00 | 0.00 | 2071.42 | 4748.04 |
| Li, Sandra,13679 | 5933.26 | 0.00 | 3578.27 | 0.00 | 2354.99 |
| Romero, Lori, A,28738 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| He, Clarence,16591 | 137.96 | 0.00 | 0.00 | 0.00 | 137.96 |
| Chen, Marshall, E,19037 | 4858.34 | 0.00 | 0.00 | 2443.35 | 2414.99 |
| Bailey, Ariana, J,13691 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Sanz, Neil, M,22622 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Martinez, Carla,24852 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Kennedy, Kelsey, M,23984 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Ruiz, Theodore,20052 | 3214.03 | 0.00 | 699.10 | 0.00 | 2514.93 |
| Jenkins, Spencer, S,14862 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Carlson, Diane, W,21074 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Anderson, Devin, A,22822 | 2475.95 | 0.00 | 0.00 | 2475.95 | 0.00 |
| Dominguez, Naomi, B,14720 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Ortega, Robyn,24104 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Yang, Jessie, E,20053 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
Generated 2025-12-24 07:35:57.835 UTC