[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 125 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jones, David, D,20866 | 3157.97 | 0.00 | 0.00 | 782.99 | 2374.98 |
| Anand, Karla,17185 | 6954.57 | 0.00 | 0.00 | 2181.56 | 4773.01 |
| Dominguez, Julio, E,17094 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Rodriguez, Stefanie, L,12459 | 5618.54 | 0.00 | 0.00 | 2071.42 | 3547.12 |
| Cox, Zoe, A,17755 | 2768.53 | 0.00 | 0.00 | 2181.56 | 586.97 |
| Gao, Mandy, M,12560 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
| Andersen, Bridget, K,17792 | 3266.81 | 0.00 | 0.00 | 2443.35 | 823.46 |
| Hill, Nathan,12615 | 5663.23 | 0.00 | 0.00 | 2071.42 | 3591.81 |
| Ye, Darryl,17790 | 3039.31 | 0.00 | 0.00 | 2443.35 | 595.96 |
| Rubio, Micheal, K,12622 | 5135.41 | 0.00 | 0.00 | 2049.10 | 3086.31 |
| Rowe, Theodore,17794 | 2745.82 | 0.00 | 0.00 | 2181.56 | 564.26 |
| Sharma, Alicia, L,19440 | 3492.76 | 0.00 | 0.00 | 1000.44 | 2492.32 |
| Kelly, Jacqueline,21034 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Jiménez, Arthur, K,20982 | 2546.96 | 0.00 | 0.00 | 2546.96 | 0.00 |
| Nelson, Luke, E,21027 | 2537.97 | 0.00 | 0.00 | 782.99 | 1754.98 |
| Liu, Alan, V,16464 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
| Ortega, Kendra,25592 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Kennedy, Kelsey, M,23984 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sanz, Juan, R,14983 | 71.27 | 0.00 | 0.00 | 0.00 | 71.27 |
| Blanco, Jacquelyn,13411 | 6819.46 | 0.00 | 0.00 | 2071.42 | 4748.04 |
| Goel, Louis,24055 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Vazquez, Jaime,22304 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Ray, Harold, A,13516 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Rodriguez, Jessica,21669 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Bell, Sebastian, D,27785 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Li, Steve,21137 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Mr., Shimshoni, Daniel,24705 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sanchez, Emmanuel, F,21856 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Chen, Gilbert, E,27906 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Munoz, Stacy,12310 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Hernandez, Ruben, C,21036 | 2547.95 | 0.00 | 0.00 | 782.99 | 1764.96 |
| Fernandez, Meagan, C,19448 | 3543.88 | 0.00 | 0.00 | 1000.44 | 2543.44 |
| Vazquez, Cheryl, A,17948 | 3045.30 | 0.00 | 0.00 | 2443.35 | 601.95 |
| Lal, Ricardo, C,17958 | 2811.52 | 0.00 | 0.00 | 2181.56 | 629.96 |
| Vance, Marie, W,21012 | 2497.96 | 0.00 | 0.00 | 782.99 | 1714.97 |
| Gonzalez, Evelyn, L,12859 | 5666.22 | 0.00 | 0.00 | 2071.42 | 3594.80 |
| Lin, Rosa,12856 | 4460.38 | 0.00 | 0.00 | 2071.42 | 2388.96 |
| Fernandez, Dominique,12839 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Patel, Kristina,17990 | 2778.52 | 0.00 | 0.00 | 2181.56 | 596.96 |
| Jimenez, Frank,21067 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Xie, Carly, R,13253 | 6774.45 | 0.00 | 0.00 | 2071.42 | 4703.03 |
| Chandra, Deanna,18141 | 6972.86 | 0.00 | 0.00 | 2181.56 | 4791.30 |
| Shan, Karla,19493 | 3515.37 | 0.00 | 0.00 | 3515.37 | 0.00 |
| Lal, Tasha, A,28408 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Navarro, Arthur,16198 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Henderson, Alexandria, R,11555 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Rana, Cynthia, L,28397 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Rai, Alicia, M,28914 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Tang, Alejandro, L,11542 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Suarez, Ross, C,27940 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Romero, Mathew, L,16043 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Johnsen, Rebekah, J,19919 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Albert,26837 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Browning, Marie,26372 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Gutierrez, Kathleen,17786 | 89.46 | 0.00 | 0.00 | 0.00 | 89.46 |
| Chen, Wesley, J,29427 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Rogers, Cody, F,26892 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Liu, Stacey, A,13557 | 4443.38 | 0.00 | 0.00 | 2071.42 | 2371.96 |
Generated 2025-12-23 06:06:13.685 UTC