[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1156 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Luo, Alejandro, K,12316 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Li, Suzanne,21508 | 3152.95 | 0.00 | 0.00 | 782.99 | 2369.96 |
| Dominguez, Julio, E,17094 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Van, Bryant,13562 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Blanco, Alfredo, T,17626 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Wang, Alvin,19939 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Gomez, Gerald,17743 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Lewis, Katherine,14816 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Torres, Janet, J,23985 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhao, Rafael,13412 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Pal, Maurice,26929 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Diaz, Austin, M,12550 | 86.75 | 0.00 | 0.00 | 0.00 | 86.75 |
| Diaz, Billy,21839 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Rubio, Rebekah,24699 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Kumar, Nichole,23236 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hernandez, Kristi, L,22635 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Gill, Philip,22599 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Gutierrez, Roberto,11355 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Madan, Phillip,27162 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Rana, Brett, L,20943 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Raji, Cristina, E,25506 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Anderson, Devin, A,22822 | 2475.95 | 0.00 | 0.00 | 2475.95 | 0.00 |
| Mr., Sneath, Timothy,17708 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Kumar, Dustin, R,26846 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Raji, Jenny,21870 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Kovár, Abby, K,25605 | 600.46 | 0.00 | 0.00 | 600.46 | 0.00 |
| Smith, Ethan,14530 | 72.86 | 0.00 | 0.00 | 0.00 | 72.86 |
| Hernandez, Adrienne, Y,22668 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Miller, Grace,22502 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Alvarez, Mallory, L,21124 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Black, Tamara, L,24202 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
Generated 2025-12-22 00:38:09.940 UTC