[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ma, Ronnie, C,17815 | 3123.78 | 0.00 | 0.00 | 2443.35 | 680.43 |
| Ward, Caitlin,16445 | 3242.83 | 0.00 | 0.00 | 2443.35 | 799.48 |
| Chande, Tamara, L,28693 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Nath, Clarence,24050 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Romero, Mathew, L,16043 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Sharma, Nichole, M,14692 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Zhu, Lisa, R,15059 | 6793.54 | 0.00 | 3578.27 | 0.00 | 3215.27 |
| Ashe, Francisco, W,12335 | 6912.60 | 0.00 | 0.00 | 2049.10 | 4863.50 |
| Ramos, Ruben, L,23762 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Andersen, Kelli,22602 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Ma, Stacey,21840 | 31.27 | 0.00 | 0.00 | 31.27 | 0.00 |
| Jai, Kelli,22530 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Deng, Ricardo,21111 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Mitchell, Isaac,14554 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Luo, Calvin, T,19172 | 1609.41 | 0.00 | 1000.44 | 0.00 | 608.97 |
| Chander, Colin, P,12847 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Zeng, Darryl, C,20929 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Tang, Russell,18632 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Alonso, Eddie, L,16420 | 2959.00 | 0.00 | 0.00 | 2181.56 | 777.44 |
| Sanchez, Gerald,24144 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rana, Tabitha, Y,16601 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Harrison, Melody,28468 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Robinson, Brandon, J,15661 | 5208.04 | 0.00 | 3578.27 | 0.00 | 1629.77 |
| Dominguez, Naomi, B,14720 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Torres, Ian, V,17207 | 6979.56 | 0.00 | 0.00 | 2181.56 | 4798.00 |
| Perez, Meagan, R,21101 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Huang, Jeffery,25755 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ross, Hailey, C,13612 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
Generated 2025-12-22 00:17:45.576 UTC