[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1375 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Li, Susan,27839 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Yang, Jessie, E,20053 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Suarez, Sheila,28884 | 11.94 | 0.00 | 0.00 | 0.00 | 11.94 |
| Sanz, Erika, J,22670 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ruiz, Ruben, A,20055 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Lal, Tony,28515 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Shen, Damien, C,14964 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Ms., Sims, Anne, R.,26869 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Gutierrez, Roberto,11355 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ms., Smith, Mary, J.,28437 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Carlson, Darren, D,29478 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Xu, Melvin, A,11474 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Lin, Vincent, A,28516 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Young, Evan,12739 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Rana, Brett, L,20943 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Alvarez, Lance, J,16190 | 79.25 | 0.00 | 0.00 | 0.00 | 79.25 |
| Henderson, Anna,24857 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jones, Lucas,27158 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Thomas, Ryan,22532 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Navarro, Audrey, S,26937 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Arun, Henry, L,27177 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Suri, Henry,21683 | 1779.47 | 0.00 | 0.00 | 0.00 | 1779.47 |
| Sara, Manuel,12611 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Wu, Crystal, W,22672 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gill, Julio, R,26993 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Li, Jorge, V,20133 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Romero, Mathew, L,16043 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| He, Jenny, C,24100 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Hu, Steve, A,16294 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Black, Tara,24216 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
Generated 2025-12-24 06:45:30.973 UTC