[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 752 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Thompson, Emma, C,19445 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Sanz, Neil, M,22622 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Parker, Eric, H,27130 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Beck, Cristina, J,12284 | 5625.25 | 0.00 | 0.00 | 2071.42 | 3553.83 |
| She, Trisha, A,18021 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Jenkins, Spencer, S,14862 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Deng, Jerry,22813 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 |
| Raje, Karl,19362 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Perez, Fernando,27848 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Ortega, Robyn,24104 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Torres, Orlando, H,27896 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Ramirez, Megan, C,11387 | 6958.80 | 0.00 | 3374.99 | 2354.98 | 1228.83 |
| Jai, Grant,24200 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Sai, Allen, E,27781 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Carlson, Melinda,20921 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Tang, Nichole, C,15630 | 5136.37 | 0.00 | 3578.27 | 806.76 | 751.34 |
| Schmidt, Theresa,21854 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Kumar, Nichole,23236 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Russell, Carson,21116 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Sun, Stacey, S,19361 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Zeng, Valerie,17977 | 2966.03 | 0.00 | 0.00 | 2181.56 | 784.47 |
| Rodriguez, Bryant, R,29360 | 2418.05 | 0.00 | 0.00 | 0.00 | 2418.05 |
| Liang, Marshall, J,25447 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Rubio, Jimmy,20837 | 2547.95 | 0.00 | 0.00 | 2547.95 | 0.00 |
| Baker, Seth,21520 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Ramos, Kari, D,24702 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Chande, Priscilla,29358 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Taylor, Joseph, T,12289 | 5645.86 | 0.00 | 0.00 | 2049.10 | 3596.76 |
| Lee, Jacob,13551 | 5622.92 | 0.00 | 0.00 | 2049.10 | 3573.82 |
| Raje, Tamara, J,19946 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Travers, Jill, A,16602 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Shen, Julie,22505 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Hu, Tiffany, A,20856 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Luo, Sharon, D,11553 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Gomez, Theodore,13503 | 101.25 | 0.00 | 0.00 | 0.00 | 101.25 |
| Yang, Jackson,22570 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Martinez, George, L,20570 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Lopez, Carolyn, L,25668 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Chen, Tamara,12382 | 5606.26 | 0.00 | 0.00 | 2071.42 | 3534.84 |
| Xu, Omar, A,22596 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Patel, Cassandra, P,12465 | 83.42 | 0.00 | 0.00 | 0.00 | 83.42 |
| Zhao, Kelli,26386 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Suarez, Michele, C,12526 | 5229.38 | 0.00 | 0.00 | 2049.10 | 3180.28 |
| Gutierrez, Craig,19049 | 4838.30 | 0.00 | 0.00 | 2443.35 | 2394.95 |
| Deng, Carly, E,22452 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Torres, Lawrence,15671 | 31.55 | 0.00 | 0.00 | 0.00 | 31.55 |
| Serrano, Kari,26905 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Sharma, Nicolas, D,13517 | 5666.38 | 0.00 | 0.00 | 2049.10 | 3617.28 |
| Miller, Grace,22502 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Anderson, Samuel, D,14199 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Sharma, Dawn,23987 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Gutierrez, Lori,24065 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Suri, Andre, D,24189 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Black, Nina, L,17968 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Gao, Martha,13582 | 77.96 | 0.00 | 0.00 | 68.97 | 8.99 |
| Becker, Karla, M,12730 | 64.90 | 0.00 | 0.00 | 0.00 | 64.90 |
| Ruiz, Roy, L,28704 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Munoz, Danny,19355 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| James, Arianna, A,25799 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Moreno, Paula, W,13554 | 5641.25 | 0.00 | 0.00 | 2071.42 | 3569.83 |
| Hill, Miguel, C,22433 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
Generated 2025-12-24 08:01:04.136 UTC