[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 9 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mrs., West, Alyssa,23219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raje, Brendan,16250 | 4511.54 | 0.00 | 0.00 | 2181.56 | 2329.98 |
| Sara, Manuel,12611 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Tang, Bonnie, W,27856 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Coleman, Jessica,13553 | 5603.24 | 0.00 | 0.00 | 2071.42 | 3531.82 |
| Li, Sandra,13679 | 5933.26 | 0.00 | 3578.27 | 0.00 | 2354.99 |
| Romero, Robyn, C,27802 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Zhao, Colleen, L,16407 | 3250.11 | 0.00 | 0.00 | 2443.35 | 806.76 |
| Coleman, Trevor, C,25313 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Tang, Gilbert, D,21533 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| Carlson, Natasha,21136 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Kumar, Peter,26915 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Chen, Valerie,19911 | 3335.41 | 0.00 | 0.00 | 1000.44 | 2334.97 |
| Zeng, Margaret, M,16191 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Madan, Donald, R,27168 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Foster, Mya, M,23230 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Deng, Sharon, A,26893 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Shen, Jaime,13765 | 7152.09 | 0.00 | 3578.27 | 0.00 | 3573.82 |
| Dominguez, Victor, K,14784 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Dominguez, Jessie, A,25628 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Washington, Destiny,22812 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Kapoor, Deanna, D,17097 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Washington, Cassidy,17701 | 34.47 | 0.00 | 0.00 | 29.48 | 4.99 |
| Subram, Holly, J,28552 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
Generated 2025-12-22 01:08:24.788 UTC