[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 188 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Suurs, Paul, J,15669 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Cai, Stacey,20575 | 3095.04 | 0.00 | 699.10 | 0.00 | 2395.94 |
| Jai, April,15660 | 5169.07 | 0.00 | 3578.27 | 0.00 | 1590.80 |
| Liang, Crystal, J,11549 | 7023.77 | 0.00 | 3399.99 | 0.00 | 3623.78 |
| Luo, Calvin, T,19172 | 1609.41 | 0.00 | 1000.44 | 0.00 | 608.97 |
| Gomez, Robyn,16046 | 3963.14 | 0.00 | 2443.35 | 0.00 | 1519.79 |
| Mehta, Ruth,15702 | 6917.54 | 0.00 | 2181.56 | 0.00 | 4735.98 |
| Collins, Blake,11610 | 6786.44 | 0.00 | 2071.42 | 0.00 | 4715.02 |
| Torres, Deb,11550 | 5241.43 | 0.00 | 2049.10 | 777.34 | 2414.99 |
| Garcia, Bob,19186 | 1562.41 | 0.00 | 1000.44 | 0.00 | 561.97 |
| Rai, Maurice, S,16328 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Ray, Chelsea, R,20717 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Sanz, Ebony, I,20711 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Wu, Rosa,16461 | 3287.32 | 0.00 | 0.00 | 2443.35 | 843.97 |
| Raje, Julie, H,12214 | 6803.92 | 0.00 | 0.00 | 2049.10 | 4754.82 |
| Ward, Caitlin,16445 | 3242.83 | 0.00 | 0.00 | 2443.35 | 799.48 |
| Xu, Jenny, K,12222 | 6909.10 | 0.00 | 0.00 | 2049.10 | 4860.00 |
| Ross, Ryan,16428 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Ramos, Alberto,12239 | 6901.42 | 0.00 | 0.00 | 2071.42 | 4830.00 |
| Diaz, Larry, T,13664 | 210.25 | 0.00 | 0.00 | 0.00 | 210.25 |
| Suri, Michele,18007 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Zhang, Cedric, D,26966 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Prasad, Sergio, J,19290 | 1605.40 | 0.00 | 0.00 | 1000.44 | 604.96 |
| Zeng, Todd, C,12283 | 5582.91 | 0.00 | 0.00 | 3272.94 | 2309.97 |
| Ashe, Bruce,12264 | 5662.90 | 0.00 | 0.00 | 3292.94 | 2369.96 |
| Navarro, Lance, C,20850 | 2556.94 | 0.00 | 0.00 | 782.99 | 1773.95 |
| Young, Gabriella, M,19305 | 1622.40 | 0.00 | 0.00 | 1000.44 | 621.96 |
| Roberts, Gabriella, J,16553 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Dominguez, Ruben,16573 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Yuan, Kurt,16561 | 3030.03 | 0.00 | 0.00 | 2181.56 | 848.47 |
| Zheng, Valerie, R,19312 | 1564.70 | 0.00 | 0.00 | 1000.44 | 564.26 |
| Ruiz, Stacy,16823 | 7242.35 | 0.00 | 0.00 | 2443.35 | 4799.00 |
| Romero, Gerald, K,19322 | 1565.43 | 0.00 | 0.00 | 1000.44 | 564.99 |
| Hu, Tiffany, A,20856 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Kelly, Brianna, C,16945 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Kapoor, Marco,19512 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Rana, Heidi, M,22475 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Chandra, Mayra,16453 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Goel, Gregory,28712 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Luo, Alejandro, K,12316 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Patterson, Jessica,17182 | 6950.60 | 0.00 | 0.00 | 2181.56 | 4769.04 |
| Yuan, Omar, C,12380 | 5570.22 | 0.00 | 0.00 | 2049.10 | 3521.12 |
| Kapoor, Deanna, D,17097 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Liu, Damien, M,17214 | 7211.39 | 0.00 | 0.00 | 2443.35 | 4768.04 |
| Jones, David, D,20866 | 3157.97 | 0.00 | 0.00 | 782.99 | 2374.98 |
| Sanchez, Pamela,20879 | 3284.30 | 0.00 | 0.00 | 782.99 | 2501.31 |
| Raje, Christine, W,17203 | 6952.53 | 0.00 | 0.00 | 2181.56 | 4770.97 |
| Torres, Ian, V,17207 | 6979.56 | 0.00 | 0.00 | 2181.56 | 4798.00 |
| Huang, Clarence, C,19341 | 3498.78 | 0.00 | 0.00 | 3498.78 | 0.00 |
| She, Carl, A,12317 | 6823.42 | 0.00 | 0.00 | 2071.42 | 4752.00 |
| Rodriguez, Ann, S,12315 | 6803.13 | 0.00 | 0.00 | 4468.16 | 2334.97 |
| Townsend, Roberto,19359 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Blanco, Alfredo, T,17626 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Morris, Caitlin,19416 | 3476.39 | 0.00 | 0.00 | 3476.39 | 0.00 |
| Sara, Henry, L,20892 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Torres, Hector, E,17700 | 2805.53 | 0.00 | 0.00 | 2805.53 | 0.00 |
| Gomez, Gerald,17743 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Jai, Shawna, W,17750 | 2888.53 | 0.00 | 0.00 | 2181.56 | 706.97 |
| Andersen, Leonard,17772 | 2846.00 | 0.00 | 0.00 | 2181.56 | 664.44 |
| Miller, Nathan, l,19418 | 3476.39 | 0.00 | 0.00 | 3476.39 | 0.00 |
| Gao, Mandy, M,12560 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
| Scott, Jason,22557 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-24 08:09:35.641 UTC