[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 15 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Dominguez, Teresa, C,20963 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Munoz, Daisy,15081 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Torres, Ian, V,17207 | 6979.56 | 0.00 | 0.00 | 2181.56 | 4798.00 |
| Zhu, Laura, M,29439 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Beck, Clayton,11579 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Nicholls, Jay, K,17813 | 3020.30 | 0.00 | 0.00 | 2443.35 | 576.95 |
| Raman, Darren, K,22315 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Harrison, Melody,28468 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Deng, Sharon, A,26893 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Alvarez, Mallory, L,21124 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Navarro, Arthur,16198 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Vazquez, Pedro, A,15686 | 72.58 | 0.00 | 0.00 | 0.00 | 72.58 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Harrison, Bianca, J,17886 | 38.97 | 0.00 | 0.00 | 0.00 | 38.97 |
| Garcia, Douglas,24860 | 2520.31 | 0.00 | 0.00 | 0.00 | 2520.31 |
| Martinez, Evelyn, J,17204 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Schmidt, Marc,12808 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Serrano, Larry,21516 | 3102.25 | 0.00 | 0.00 | 782.99 | 2319.26 |
| Romero, Alberto,11586 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Lopez, Harold,26913 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Hill, Nathan,12615 | 5663.23 | 0.00 | 0.00 | 2071.42 | 3591.81 |
| Jackson, Kayla, R,20060 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Diaz, Krista,28913 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sun, Alejandro, B,23923 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Hu, Candice,27818 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Carlson, Kristine, C,28753 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Jones, Chloe,20838 | 2541.94 | 0.00 | 0.00 | 782.99 | 1758.95 |
| Liu, Mandy,17888 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Gao, Claudia,13690 | 7162.08 | 0.00 | 3578.27 | 0.00 | 3583.81 |
Generated 2025-12-21 13:33:33.052 UTC