[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 890 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raman, George, M,26359 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Zhang, Jake,22616 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Serrano, Kari,26905 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Shen, Damien, C,14964 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Sharma, Dawn,23987 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Ms., Smith, Mary, J.,28437 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Gao, Martha,13582 | 77.96 | 0.00 | 0.00 | 68.97 | 8.99 |
| Lin, Vincent, A,28516 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| James, Arianna, A,25799 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Washington, Destiny,22812 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Sai, Dominique,28908 | 33.43 | 0.00 | 0.00 | 33.43 | 0.00 |
| Bryant, Marissa, A,28892 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Gonzales, Emma, P,15681 | 105.56 | 0.00 | 0.00 | 33.98 | 71.58 |
| Jimenez, Michele,13547 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
Generated 2025-12-24 06:05:47.028 UTC