[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 6 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ms., Smith, Samantha,29407 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Robinson, Nicole,28730 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Morgan, Makayla, C,27156 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Carlson, Jamie,23770 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Anand, Tonya, A,27141 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Jones, David, D,20866 | 3157.97 | 0.00 | 0.00 | 782.99 | 2374.98 |
| Ramos, Daisy,14552 | 103.97 | 0.00 | 0.00 | 0.00 | 103.97 |
| Romero, Lori, A,28738 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sai, Stanley,13675 | 215.23 | 0.00 | 0.00 | 0.00 | 215.23 |
| Serrano, Jonathon, F,23954 | 1178.45 | 0.00 | 0.00 | 0.00 | 1178.45 |
| Kovár, Abby, K,25605 | 600.46 | 0.00 | 0.00 | 600.46 | 0.00 |
| Gutierrez, Roberto,11355 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Black, Nichole,22422 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Nara, Shawn, C,13845 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Gonzales, Jessica, A,15610 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Tang, Devon, L,24132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chow, Jamie,27815 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 |
| Xu, Terrence, L,23743 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hernandez, Naomi,25686 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Evans, Kyle,27890 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Madan, Gerald, E,15653 | 5204.06 | 0.00 | 3578.27 | 0.00 | 1625.79 |
| Jenkins, Kayla, A,14777 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| Zhang, Randy,12601 | 55.91 | 0.00 | 0.00 | 0.00 | 55.91 |
| Malhotra, Michele, A,26896 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
Generated 2025-12-22 07:18:12.033 UTC