[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 845 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Henderson, Tristan,12224 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
| Chander, Nichole, H,28451 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Hu, Curtis, G,27880 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Anand, Lindsey, K,22592 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Kapoor, Jermaine, A,29368 | 2422.54 | 0.00 | 0.00 | 0.00 | 2422.54 |
| Sandoval, Jill,14143 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
| Yang, Marshall, E,12564 | 110.75 | 0.00 | 0.00 | 0.00 | 110.75 |
| She, Clayton,13785 | 121.83 | 0.00 | 0.00 | 0.00 | 121.83 |
| Perez, Fernando,27848 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Navarro, Arthur,16198 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Alonso, Felicia, A,26842 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Torres, Juan, M,12746 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Rana, Cynthia, L,28397 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Howard, Makayla,16251 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Navarro, Dwayne, H,11615 | 5205.71 | 0.00 | 0.00 | 2848.76 | 2356.95 |
| Chapman, Bob, W,21134 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Zhang, Candice, J,23777 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Jai, Grant,24200 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Gutierrez, Walter,25141 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanz, Jaime, C,19928 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Dominguez, Clinton,15933 | 6931.88 | 0.00 | 2181.56 | 0.00 | 4750.32 |
| Carlson, Ruben, J,25304 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Jimenez, Joe,19071 | 115.95 | 0.00 | 0.00 | 0.00 | 115.95 |
| Guo, Roger,13539 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Schmidt, Mayra,17884 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Shan, Alicia,27964 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Tang, Jaclyn, K,21060 | 2508.47 | 0.00 | 0.00 | 782.99 | 1725.48 |
| Zhang, Franklin, L,12597 | 53.21 | 0.00 | 0.00 | 0.00 | 53.21 |
| Lopez, Bryant,24218 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Henderson, Faith,14545 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Tang, Alejandro, L,11542 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Hernandez, Ruben, C,21036 | 2547.95 | 0.00 | 0.00 | 782.99 | 1764.96 |
| Andersen, Keith,11612 | 6795.12 | 0.00 | 2049.10 | 0.00 | 4746.02 |
| Chandra, Bruce, H,14970 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Rubio, Lance, E,19477 | 3533.77 | 0.00 | 0.00 | 3533.77 | 0.00 |
| Schmidt, Gina,16260 | 3001.02 | 0.00 | 2181.56 | 0.00 | 819.46 |
| Xu, Katie, R,14799 | 162.95 | 0.00 | 0.00 | 0.00 | 162.95 |
| Romero, Reginald, F,12854 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| McDonald, Deborah, R,16275 | 3282.83 | 0.00 | 2443.35 | 0.00 | 839.48 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Martinez, Bryant,19471 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Schmidt, Theresa,21854 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Romero, Mathew, L,16043 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Raje, Kate,17974 | 2791.46 | 0.00 | 0.00 | 2181.56 | 609.90 |
| Raman, Joel,16317 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Nath, Sheena,25800 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Yuan, Katie,19459 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Sai, Adriana, A,16405 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Suarez, Kristine,16282 | 64.25 | 0.00 | 0.00 | 0.00 | 64.25 |
| Jimenez, Frank,21067 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Zeng, Valerie,17977 | 2966.03 | 0.00 | 0.00 | 2181.56 | 784.47 |
| Sun, Alisha,18048 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Hernandez, Francis,21103 | 2506.95 | 0.00 | 0.00 | 782.99 | 1723.96 |
| Xu, Shawn,19328 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Lu, Dawn, G,27833 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Carlson, Felicia,19502 | 3565.36 | 0.00 | 0.00 | 1000.44 | 2564.92 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 0.00 | 782.99 | 2638.94 |
| Howard, Jennifer,16264 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Schmidt, Derrick, R,22605 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Rivera, Seth,17879 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Hill, Gabriella,26364 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Jai, Shawn, E,25501 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
Generated 2025-12-24 06:26:07.125 UTC