[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 326 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rogers, Cody, F,26892 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ruiz, Audrey,12645 | 6847.76 | 0.00 | 0.00 | 2071.42 | 4776.34 |
| Liu, Stacey, A,13557 | 4443.38 | 0.00 | 0.00 | 2071.42 | 2371.96 |
| Xie, Alejandro,25781 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Raje, Tamara, J,19946 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Subram, Meagan, W,11573 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Sanchez, Brenda,25656 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Navarro, Lee,25659 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Deng, Tonya, O,17936 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Shan, Cedric, H,23775 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gomez, Theodore,13503 | 101.25 | 0.00 | 0.00 | 0.00 | 101.25 |
| McDonald, Gilbert, G,17226 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Suarez, Jaime, L,15056 | 6749.05 | 0.00 | 3578.27 | 0.00 | 3170.78 |
| Li, Steve,21137 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Fernandez, Ruben,19927 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ortega, Nelson,15118 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Mr., Shimshoni, Daniel,24705 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Xu, Jenny, K,12222 | 6909.10 | 0.00 | 0.00 | 2049.10 | 4860.00 |
| Gutierrez, Teresa, A,15083 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Cai, Colleen, J,15088 | 5896.19 | 0.00 | 3578.27 | 0.00 | 2317.92 |
| Patel, Troy,14968 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Barnes, Isabelle, C,15453 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Gonzalez, Tammy, J,25657 | 609.45 | 0.00 | 0.00 | 0.00 | 609.45 |
| Muñoz, Dana,28459 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Chen, Heather, M,29408 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Simmons, Faith, S,15614 | 6059.18 | 0.00 | 3578.27 | 0.00 | 2480.91 |
| Jai, Damien,14806 | 242.94 | 0.00 | 0.00 | 0.00 | 242.94 |
| Sanchez, Emmanuel, F,21856 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Wu, Dawn, T,11493 | 6958.80 | 0.00 | 3399.99 | 0.00 | 3558.81 |
Generated 2025-12-23 11:52:52.602 UTC