[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 781 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Jonathan, D,15103 | 107.85 | 0.00 | 0.00 | 0.00 | 107.85 |
| Zhao, Edwin,14991 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Prasad, Rachael, M,22535 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Sanz, Krista,27806 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Wang, Alvin,19939 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Rogers, Brianna,22536 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Gill, Julio, R,26993 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Zhu, Arturo, M,24575 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raji, Raul, P,21135 | 103.95 | 0.00 | 0.00 | 0.00 | 103.95 |
| Raman, Kristina,26932 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Alvarez, Cheryl, A,12320 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Schmidt, Gina,16260 | 3001.02 | 0.00 | 2181.56 | 0.00 | 819.46 |
| Chandra, Roy, R,24583 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Holt, Roger,27140 | 575.71 | 0.00 | 0.00 | 0.00 | 575.71 |
| McDonald, Deborah, R,16275 | 3282.83 | 0.00 | 2443.35 | 0.00 | 839.48 |
| Hughes, Amanda,16189 | 105.94 | 0.00 | 0.00 | 0.00 | 105.94 |
| Dominguez, Albert,27125 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Ramos, Ruben, L,23762 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Raman, Meredith,11381 | 8161.02 | 0.00 | 3399.99 | 2341.97 | 2419.06 |
| Gonzalez, Tammy, J,25657 | 609.45 | 0.00 | 0.00 | 0.00 | 609.45 |
| Black, Tara,24216 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Srini, Martin, L,18629 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sai, Adriana, A,16405 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Andersen, Kelli,22602 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Walker, Madison,17105 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Zhang, Arturo, V,26891 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 0.00 | 782.99 | 2638.94 |
| Tang, Russell,18632 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Nara, Roger,26928 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
Generated 2025-12-24 06:29:00.292 UTC