[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 48 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Kovar, Shane, L,12294 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Gill, Alfredo, M,23629 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| Pal, Michele,17814 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Hernandez, Maria,14950 | 6709.59 | 0.00 | 3578.27 | 0.00 | 3131.32 |
| Gonzales, Jessica, A,15610 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Srini, Ebony, A,17959 | 2748.83 | 0.00 | 0.00 | 2181.56 | 567.27 |
| Morgan, Kimberly, A,28735 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Tang, Nicolas, S,12282 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Liang, Heather, E,20552 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Morris, Jacqueline, H,29468 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Prasad, Virginia,17933 | 3103.31 | 0.00 | 0.00 | 2443.35 | 659.96 |
| Lee, Emily,20585 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Randall, Tammy, C,13798 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Washington, Cassidy,17701 | 34.47 | 0.00 | 0.00 | 29.48 | 4.99 |
| Price, Wyatt,12336 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Alonso, Theodore,24186 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Sanz, Erika, J,22670 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raje, Julie, H,12214 | 6803.92 | 0.00 | 0.00 | 2049.10 | 4754.82 |
| Campbell, Katherine, P,28448 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Rodriguez, Marie, L,17960 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Ortega, Robin,17798 | 3058.31 | 0.00 | 0.00 | 2443.35 | 614.96 |
| Liang, Wesley, A,12123 | 5837.84 | 0.00 | 0.00 | 2049.10 | 3788.74 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
Generated 2025-12-23 06:56:39.865 UTC