[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 27 > < TAKE 32 >
32 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gill, Kristi, A,27171 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Jai, Damien,14806 | 242.94 | 0.00 | 0.00 | 0.00 | 242.94 |
| Sun, Claudia, J,14525 | 6665.58 | 0.00 | 3578.27 | 0.00 | 3087.31 |
| Hernandez, Mason, C,27782 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Carlson, Linda, J,12609 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
| Gonzalez, Stefanie, J,28709 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Gutierrez, Arthur, A,12504 | 61.08 | 0.00 | 0.00 | 0.00 | 61.08 |
| Cook, Rachel, T,23614 | 144.45 | 0.00 | 0.00 | 0.00 | 144.45 |
| Wang, Kyle,20599 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Lin, Brent, L,27788 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Chandra, Ronald, H,20801 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Rana, Summer, M,25703 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Malhotra, Troy,11569 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Lopez, Geoffrey, A,29451 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Lopez, Emmanuel, R,12559 | 5633.91 | 0.00 | 0.00 | 2049.10 | 3584.81 |
| Sun, Alejandro, B,23923 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Martin, Audrey,13791 | 107.85 | 0.00 | 0.00 | 0.00 | 107.85 |
| Martin, Paula, B,21855 | 579.97 | 0.00 | 0.00 | 0.00 | 579.97 |
| Alonso, Kendra, C,16427 | 2975.02 | 0.00 | 0.00 | 2975.02 | 0.00 |
| Sanchez, Edgar,11604 | 6786.12 | 0.00 | 2049.10 | 0.00 | 4737.02 |
| Jenkins, Devin,22383 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Fernandez, Kari,13788 | 200.81 | 0.00 | 0.00 | 0.00 | 200.81 |
| Travers, Linda,29420 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Rai, Donna,12235 | 62.76 | 0.00 | 0.00 | 0.00 | 62.76 |
| Huang, Alvin,12491 | 86.58 | 0.00 | 0.00 | 0.00 | 86.58 |
| Carlson, Gloria, P,15632 | 5245.06 | 0.00 | 3578.27 | 0.00 | 1666.79 |
| Huang, Clarence, C,19341 | 3498.78 | 0.00 | 0.00 | 3498.78 | 0.00 |
| Diaz, Julio, J,24094 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Rana, Cassandra,13407 | 6904.10 | 0.00 | 0.00 | 2049.10 | 4855.00 |
| Diaz, Jimmy, D,25474 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Martin, Joy, L,13544 | 108.44 | 0.00 | 0.00 | 0.00 | 108.44 |
Generated 2025-12-24 06:08:08.443 UTC