[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 188 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Navarro, Lee,25659 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Lal, Johnny, G,12381 | 5161.73 | 0.00 | 0.00 | 2071.42 | 3090.31 |
| Zhou, Lisa, L,13809 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Alvarez, Micheal, W,13495 | 57.95 | 0.00 | 0.00 | 0.00 | 57.95 |
| Shan, Cedric, H,23775 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Patel, Stefanie,27967 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Jai, Shawna, W,17750 | 2888.53 | 0.00 | 0.00 | 2181.56 | 706.97 |
| Washington, Haley, F,23904 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Anand, Colleen, N,12647 | 6886.60 | 0.00 | 0.00 | 2049.10 | 4837.50 |
| Ramos, Pedro, P,29416 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Sara, Bruce,22311 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Moreno, Derrick, C,18625 | 2753.82 | 0.00 | 0.00 | 2181.56 | 572.26 |
| Suarez, Shannon, R,12633 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Sharma, James, L,21049 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Ross, Gabrielle, J,19253 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Sanders, Richard, D,21511 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Rodriguez, Cindy,26379 | 1783.96 | 0.00 | 0.00 | 0.00 | 1783.96 |
| Hu, Darryl,24868 | 2501.31 | 0.00 | 0.00 | 0.00 | 2501.31 |
| Morgan, Sean,14993 | 152.94 | 0.00 | 0.00 | 0.00 | 152.94 |
| Dominguez, Clinton,15933 | 6931.88 | 0.00 | 2181.56 | 0.00 | 4750.32 |
| Perez, Frederick,16053 | 3752.38 | 0.00 | 2181.56 | 0.00 | 1570.82 |
| Beck, Carl, M,16311 | 2988.32 | 0.00 | 2181.56 | 806.76 | 0.00 |
| He, Warren, L,17192 | 6977.58 | 0.00 | 0.00 | 2181.56 | 4796.02 |
| Schmidt, Gina,16260 | 3001.02 | 0.00 | 2181.56 | 0.00 | 819.46 |
| Henderson, Dakota, M,16406 | 3110.05 | 0.00 | 2181.56 | 928.49 | 0.00 |
| Chander, Sheena, L,16308 | 4551.52 | 0.00 | 2181.56 | 0.00 | 2369.96 |
| Li, Curtis, E,13692 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sai, Adriana, A,16405 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Raman, Darren, K,22315 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lal, Omar, S,19193 | 1609.40 | 0.00 | 0.00 | 1000.44 | 608.96 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 0.00 | 782.99 | 2638.94 |
Generated 2025-12-22 02:41:53.228 UTC