[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 40 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Dominguez, Carolyn, F,22653 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Serrano, Daisy, P,24187 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Nara, Alisha, D,26959 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Rai, Dustin, J,26417 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Martinez, Molly, S,13603 | 133.94 | 0.00 | 0.00 | 0.00 | 133.94 |
| Malhotra, Evelyn,12853 | 4354.08 | 0.00 | 0.00 | 2049.10 | 2304.98 |
| Gonzales, Katherine, R,13408 | 6792.12 | 0.00 | 0.00 | 2049.10 | 4743.02 |
| Scott, Dalton,14975 | 5957.22 | 0.00 | 3578.27 | 0.00 | 2378.95 |
| Sanz, Erika, J,22670 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sharma, Dawn,23987 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Baker, Katherine,19334 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Gutierrez, Kathleen,17786 | 89.46 | 0.00 | 0.00 | 0.00 | 89.46 |
| Liu, Willie,20561 | 3139.09 | 0.00 | 699.10 | 0.00 | 2439.99 |
| Dominguez, Albert,27125 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Ramos, Latasha, L,22540 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Zheng, Trisha,22437 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Mr., Sazanovich, Vadim,14847 | 6725.57 | 0.00 | 3578.27 | 0.00 | 3147.30 |
| Blanco, Jessie, R,23608 | 2510.94 | 0.00 | 0.00 | 0.00 | 2510.94 |
| Carlson, Derrick, R,28436 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Taylor, Blake, S,17889 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Washington, Cassidy,17701 | 34.47 | 0.00 | 0.00 | 29.48 | 4.99 |
| Garcia, Carla,14172 | 75.74 | 0.00 | 0.00 | 0.00 | 75.74 |
| Alvarez, Theodore,25690 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Alonso, Latasha, A,13591 | 8355.27 | 3578.27 | 0.00 | 0.00 | 4777.00 |
Generated 2025-12-22 07:18:17.616 UTC