[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 64 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Malhotra, Ebony,11589 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Goel, Kathryn,12740 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Perez, Frederick,16053 | 3752.38 | 0.00 | 2181.56 | 0.00 | 1570.82 |
| Kim, Carmen,25502 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Torres, Renee, L,19510 | 3451.74 | 0.00 | 0.00 | 1000.44 | 2451.30 |
| Ramos, Darren,25470 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Moreno, Derrick, C,18625 | 2753.82 | 0.00 | 0.00 | 2181.56 | 572.26 |
| Madan, Phillip,27162 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Lin, Brent, L,27788 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Harrison, Bianca, J,17886 | 38.97 | 0.00 | 0.00 | 0.00 | 38.97 |
| Navarro, Beth,13534 | 86.24 | 0.00 | 0.00 | 0.00 | 86.24 |
| Zhu, Stacey, E,22636 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Raje, Kenneth,23606 | 2543.44 | 0.00 | 0.00 | 2543.44 | 0.00 |
| Xie, Tommy, J,29425 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Vance, Erick,28742 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Nara, Damien, W,26877 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ward, Mackenzie, D,21130 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Raje, Tony,24212 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Mehta, George, L,20566 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Srini, Cesar,11563 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Raman, Rebekah, E,22454 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Zeng, Martha, J,17844 | 196.26 | 0.00 | 0.00 | 0.00 | 196.26 |
| Sharma, James, L,21049 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Mr., Rodman, Jim,20562 | 2994.09 | 0.00 | 699.10 | 0.00 | 2294.99 |
| Gill, Adrienne,14953 | 202.46 | 0.00 | 0.00 | 0.00 | 202.46 |
| Madan, Gerald, E,15653 | 5204.06 | 0.00 | 3578.27 | 0.00 | 1625.79 |
| Ramos, Latasha, L,22540 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gutierrez, Teresa, A,15083 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
Generated 2025-12-22 02:30:01.987 UTC