[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 311 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yuan, Cedric,15449 | 49.56 | 0.00 | 0.00 | 0.00 | 49.56 |
| Rai, Dustin, J,26417 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Lin, Erica, E,16033 | 3743.39 | 0.00 | 2181.56 | 0.00 | 1561.83 |
| Anderson, Samuel, D,14199 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Vance, Regina, M,14984 | 6699.57 | 0.00 | 3578.27 | 0.00 | 3121.30 |
| Ashe, Melvin,26817 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Gonzalez, Cassandra,17967 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Ma, Suzanne, A,26947 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
| Gonzalez, Troy, A,28517 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Subram, Carmen, J,29473 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Nara, Shawn, C,13845 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Perez, Holly, E,12376 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Sun, Rosa,26900 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Nara, Roger,26928 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Reed, Cole,12603 | 117.45 | 0.00 | 0.00 | 0.00 | 117.45 |
| Lal, Ashlee, A,28417 | 2426.00 | 0.00 | 0.00 | 0.00 | 2426.00 |
| Nara, Jaime, D,13262 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Romero, Reginald, F,12854 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| Sanchez, Brett,12608 | 5689.88 | 0.00 | 0.00 | 2049.10 | 3640.78 |
| Chander, Jenny, A,19917 | 3369.41 | 0.00 | 0.00 | 1000.44 | 2368.97 |
| Gutierrez, Roberto,11355 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gao, Margaret,16401 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Xu, Melvin, A,11474 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Wang, Lisa, J,17205 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Martinez, Deanna,17202 | 6974.06 | 0.00 | 0.00 | 2181.56 | 4792.50 |
| Prasad, Cynthia, L,14808 | 164.20 | 0.00 | 0.00 | 0.00 | 164.20 |
| Rana, Brett, L,20943 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Ramos, Erik, M,25312 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Jones, Lucas,27158 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Chow, Jamie,27815 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 |
| Sanz, Mallory,14938 | 107.97 | 0.00 | 0.00 | 0.00 | 107.97 |
| Howard, Angel, A,23223 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Garcia, Meredith,17110 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Howard, Victoria, L,21525 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Zhou, Glenn, A,12326 | 63.98 | 0.00 | 0.00 | 0.00 | 63.98 |
| Torres, Randall,25646 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Jimenez, Nelson,14697 | 6684.58 | 0.00 | 3578.27 | 0.00 | 3106.31 |
| Fernandez, Stanley, R,24064 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
| Ortega, Carrie, L,11353 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Suarez, Shannon, R,12633 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Martinez, Tabitha,26865 | 123.99 | 0.00 | 0.00 | 0.00 | 123.99 |
| Andersen, Clayton,15631 | 5122.39 | 0.00 | 3578.27 | 0.00 | 1544.12 |
| Perez, Frederick,16053 | 3752.38 | 0.00 | 2181.56 | 0.00 | 1570.82 |
| Vance, Erick,28742 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Shen, Maurice, L,26938 | 722.77 | 0.00 | 0.00 | 0.00 | 722.77 |
| Hayes, Seth, C,17757 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Chen, Heather, M,29408 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Alonso, Albert, M,17645 | 132.27 | 0.00 | 0.00 | 0.00 | 132.27 |
| Martin, Victor, L,26885 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Sharma, Dylan,19066 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Carlson, Natasha,21136 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Gutierrez, Shannon, L,17101 | 163.94 | 0.00 | 0.00 | 0.00 | 163.94 |
| Alonso, Briana,21830 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gill, Randall, A,18165 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Gill, Philip,22599 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Chander, Warren, A,17965 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Butler, Adam,27925 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sanchez, Jesse, M,12623 | 5630.21 | 0.00 | 0.00 | 2049.10 | 3581.11 |
| Jenkins, Connor,20800 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
Generated 2025-12-24 06:21:01.973 UTC