[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 783 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Gomez, Gerald,17743 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Washington, Isabella,20880 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Howard, Makayla,16251 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
| Sanz, Jaime, C,19928 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Shan, Alicia,27964 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Lopez, Bryant,24218 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Blanco, Jacquelyn,13411 | 6819.46 | 0.00 | 0.00 | 2071.42 | 4748.04 |
| Patel, Manuel, M,20889 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Yuan, Alison, K,24574 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Gutierrez, Walter,25141 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Smith, Jacob, A,22418 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Patel, Rebekah, R,22396 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Muñoz, Armando, E,19906 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Wang, Kyle,20599 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Perry, Hailey, G,20721 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gutierrez, Kellie, K,17966 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Hill, Gabriella,26364 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Mitchell, Fernando,17981 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Sun, Trisha,22442 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Romero, Reginald, F,12854 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| Deng, Jerry,22813 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 |
| Gonzalez, Evelyn, L,12859 | 5666.22 | 0.00 | 0.00 | 2071.42 | 3594.80 |
| Thompson, Emma, C,19445 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Lin, Rosa,12856 | 4460.38 | 0.00 | 0.00 | 2071.42 | 2388.96 |
| Gomez, Larry, S,25778 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Schmidt, Marc,12808 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Perez, Fernando,27848 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Lin, Lisa, A,17979 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| Diaz, Reginald, A,24581 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Munoz, Walter,21056 | 2547.95 | 0.00 | 0.00 | 2547.95 | 0.00 |
| Jai, Grant,24200 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Wu, Rafael,12745 | 5199.72 | 0.00 | 0.00 | 2071.42 | 3128.30 |
| Miller, Jeremiah,17717 | 2840.01 | 0.00 | 0.00 | 2181.56 | 658.45 |
| Gray, Jessica,19479 | 3443.79 | 0.00 | 0.00 | 1000.44 | 2443.35 |
| Liang, Krystal, S,12404 | 5251.71 | 0.00 | 0.00 | 2071.42 | 3180.29 |
| Raje, Kate,17974 | 2791.46 | 0.00 | 0.00 | 2181.56 | 609.90 |
| Rai, Priscilla, C,12619 | 5200.41 | 0.00 | 0.00 | 2049.10 | 3151.31 |
| Vazquez, Jamie,21053 | 2542.96 | 0.00 | 0.00 | 782.99 | 1759.97 |
| Zhou, Valerie, J,17828 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Gutierrez, Gina, A,21092 | 2511.26 | 0.00 | 0.00 | 782.99 | 1728.27 |
| He, Wesley, I,17849 | 3025.53 | 0.00 | 0.00 | 2181.56 | 843.97 |
| Ward, Mackenzie, D,21130 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Rai, Kelsey, L,19437 | 3480.38 | 0.00 | 0.00 | 3480.38 | 0.00 |
| He, Alisha, R,18026 | 2988.32 | 0.00 | 0.00 | 2181.56 | 806.76 |
| Ramos, Jill,21039 | 2483.98 | 0.00 | 0.00 | 2483.98 | 0.00 |
| Hernandez, Francis,21103 | 2506.95 | 0.00 | 0.00 | 782.99 | 1723.96 |
| Jiménez, Arthur, K,20982 | 2546.96 | 0.00 | 0.00 | 2546.96 | 0.00 |
| He, Franklin, K,18127 | 6982.07 | 0.00 | 0.00 | 2181.56 | 4800.51 |
| Romero, Joe, J,17943 | 2781.54 | 0.00 | 0.00 | 2181.56 | 599.98 |
| Diaz, Blake, E,18135 | 6921.58 | 0.00 | 0.00 | 2181.56 | 4740.02 |
| Li, Jeffery,17969 | 3040.31 | 0.00 | 0.00 | 2443.35 | 596.96 |
| Martinez, Evelyn, J,17204 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Alvarez, Theodore,25690 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Munoz, Roberto,17628 | 106.24 | 0.00 | 0.00 | 7.28 | 98.96 |
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Gutierrez, Casey,12519 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Navarro, Arthur,16198 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Gill, Krista,12664 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Ortega, Walter,28377 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
Generated 2025-12-22 02:38:02.774 UTC