[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 23 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jimenez, Nelson,14697 | 6684.58 | 0.00 | 3578.27 | 0.00 | 3106.31 |
| Sara, Manuel,12611 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Nath, Casey,11616 | 5253.65 | 0.00 | 2071.42 | 784.28 | 2397.95 |
| Vazquez, Pedro, A,15686 | 72.58 | 0.00 | 0.00 | 0.00 | 72.58 |
| Ramos, Linda,23598 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Gonzalez, Ruben, A,22468 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Garcia, Douglas,24860 | 2520.31 | 0.00 | 0.00 | 0.00 | 2520.31 |
| Shen, Derek, T,22586 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Howard, Victoria, L,21525 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Thompson, Emma, C,19445 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Henderson, Dakota, M,16406 | 3110.05 | 0.00 | 2181.56 | 928.49 | 0.00 |
| Lal, Lindsay, H,20557 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Raji, Cristina, E,25506 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Diaz, Stephanie,15694 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Shan, Sharon, A,24211 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Li, Susan,27839 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Prasad, Cynthia, L,14808 | 164.20 | 0.00 | 0.00 | 0.00 | 164.20 |
| Chander, Christy, E,21548 | 36.93 | 0.00 | 0.00 | 0.00 | 36.93 |
| Zhou, Curtis,25505 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Tang, Jaclyn, K,21060 | 2508.47 | 0.00 | 0.00 | 782.99 | 1725.48 |
| Sanchez, Gerald,24144 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cook, Rachel, T,23614 | 144.45 | 0.00 | 0.00 | 0.00 | 144.45 |
| Schmidt, Derrick, R,22605 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Ye, Randy, G,29367 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Alonso, Latasha, A,13591 | 8355.27 | 3578.27 | 0.00 | 0.00 | 4777.00 |
| Deng, Shawn, C,16590 | 168.95 | 0.00 | 0.00 | 0.00 | 168.95 |
| Rana, Martin,24213 | 1214.46 | 0.00 | 0.00 | 0.00 | 1214.46 |
| Muñoz, Kari,19520 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Jimenez, Renee,14778 | 6673.53 | 0.00 | 3578.27 | 0.00 | 3095.26 |
| Alonso, Joy, A,19918 | 3360.41 | 0.00 | 0.00 | 1000.44 | 2359.97 |
| Barnes, Isabelle, C,15453 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Lin, Curtis, N,21858 | 2492.32 | 0.00 | 0.00 | 2492.32 | 0.00 |
| Chander, Peter, L,14836 | 115.25 | 0.00 | 0.00 | 0.00 | 115.25 |
| Jenkins, Devin,22383 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Martinez, Tabitha,26865 | 123.99 | 0.00 | 0.00 | 0.00 | 123.99 |
| Deng, Misty,14861 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Coleman, Christian,25798 | 2452.34 | 0.00 | 0.00 | 0.00 | 2452.34 |
| Raje, Andres,20710 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Ruiz, Pedro,24034 | 1203.46 | 0.00 | 0.00 | 0.00 | 1203.46 |
| Perez, Meredith, A,23597 | 2482.23 | 0.00 | 0.00 | 2482.23 | 0.00 |
| Tang, Kurt, G,13847 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
| Shan, Tommy, H,22614 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Madan, Joel, C,17887 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Gomez, Kristine, E,18627 | 3027.32 | 0.00 | 0.00 | 2443.35 | 583.97 |
| Martinez, Evelyn, J,17204 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Wood, Riley,14705 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| Rai, Arturo, T,22504 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Anand, Dustin,14535 | 123.47 | 0.00 | 0.00 | 0.00 | 123.47 |
| Zhao, Stacey, J,28365 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Allen, Jada,26866 | 615.46 | 0.00 | 0.00 | 0.00 | 615.46 |
| Rana, Marie, A,27308 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Mehta, Virginia,13602 | 8376.28 | 3578.27 | 0.00 | 0.00 | 4798.01 |
| Sanders, Richard, D,21511 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Sanz, Naomi,12840 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jai, Lindsey, W,23971 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
Generated 2025-12-23 11:55:36.147 UTC