[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 36 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wang, Tamara, L,17881 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Gutierrez, Alberto, R,15461 | 88.96 | 0.00 | 0.00 | 0.00 | 88.96 |
| Gonzalez, Dominic, L,13693 | 7171.58 | 0.00 | 3578.27 | 0.00 | 3593.31 |
| Liang, Clayton, E,14958 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Rana, Geoffrey,28745 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Simmons, Wyatt, V,22604 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Fernandez, Ruben,19927 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhu, Autumn,14840 | 157.96 | 0.00 | 0.00 | 0.00 | 157.96 |
| Moreno, Carrie, W,27151 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Washington, Faith,20849 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chapman, Joel,19050 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Guo, Wesley,16470 | 3021.04 | 0.00 | 0.00 | 2181.56 | 839.48 |
| Coleman, Gabriel, B,17706 | 37.93 | 0.00 | 0.00 | 0.00 | 37.93 |
| Jai, April,15660 | 5169.07 | 0.00 | 3578.27 | 0.00 | 1590.80 |
| Suarez, Reginald,18177 | 7043.56 | 0.00 | 0.00 | 2181.56 | 4862.00 |
| Young, Gabriella, M,19305 | 1622.40 | 0.00 | 0.00 | 1000.44 | 621.96 |
| Rodriguez, Deanna,25611 | 564.48 | 0.00 | 0.00 | 564.48 | 0.00 |
| McDonald, Deborah, R,16275 | 3282.83 | 0.00 | 2443.35 | 0.00 | 839.48 |
| Yuan, Arturo,20968 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Simmons, Kevin,12630 | 6825.46 | 0.00 | 0.00 | 2071.42 | 4754.04 |
| Shan, Russell,19500 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Zhao, Stacey, J,28365 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Diaz, Alexandria,19926 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Evans, Hunter,25493 | 1243.44 | 0.00 | 0.00 | 0.00 | 1243.44 |
| Prasad, Sergio, J,19290 | 1605.40 | 0.00 | 0.00 | 1000.44 | 604.96 |
| Prasad, Pedro, D,19077 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Xie, Louis, B,13590 | 8306.30 | 3578.27 | 0.00 | 0.00 | 4728.03 |
| Suarez, Michele, C,12526 | 5229.38 | 0.00 | 0.00 | 2049.10 | 3180.28 |
| Liang, Crystal, J,11549 | 7023.77 | 0.00 | 3399.99 | 0.00 | 3623.78 |
| Randall, Mayra,27909 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Howard, Makayla,16251 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Chandra, Marie, A,25775 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Martin, Janet, L,24540 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Sanchez, Preston, J,12506 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Ramos, Ruben, L,23762 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Torres, Shannon,12612 | 5657.91 | 0.00 | 0.00 | 2049.10 | 3608.81 |
| Ms., Li, Amy, J,12592 | 51.96 | 0.00 | 0.00 | 0.00 | 51.96 |
| Carlson, Tyrone, S,22662 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bell, Sebastian, D,27785 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Serrano, Jimmy, L,17632 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| Alvarez, Deanna, K,24720 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Torres, Deb,11550 | 5241.43 | 0.00 | 2049.10 | 777.34 | 2414.99 |
| Garcia, Kristopher, M,19070 | 4748.33 | 0.00 | 0.00 | 2443.35 | 2304.98 |
| Castro, Jacquelyn,21093 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Rai, Arturo, T,22504 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ma, Suzanne, A,26947 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
| Gomez, Larry, S,25778 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Sanchez, Morgan, J,12262 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Gill, Jill, J,26870 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Rogers, Bryan,26890 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Kumar, Grant, A,25510 | 1212.95 | 0.00 | 0.00 | 0.00 | 1212.95 |
| Thomas, Ryan,22532 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lal, Ashlee, A,28417 | 2426.00 | 0.00 | 0.00 | 0.00 | 2426.00 |
| Gonzalez, Troy, A,28517 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Raman, Douglas,24545 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
Generated 2025-12-23 05:48:29.333 UTC