[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alvarez, Lori, C,26662 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Thompson, Jonathan,27017 | 4502.14 | 0.00 | 0.00 | 2049.10 | 2453.04 |
| Sanders, Sydney,27073 | 4433.17 | 0.00 | 0.00 | 2049.10 | 2384.07 |
| Andersen, Bridget, K,17792 | 3266.81 | 0.00 | 0.00 | 2443.35 | 823.46 |
| Ross, Chloe, L,29404 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Washington, Taylor,21266 | 4525.07 | 0.00 | 0.00 | 2049.10 | 2475.97 |
| Raji, Calvin, A,15531 | 1622.47 | 0.00 | 0.00 | 782.99 | 839.48 |
| Peterson, Destiny,15537 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 |
| Anand, Johnny,14058 | 5652.52 | 0.00 | 0.00 | 2071.42 | 3581.10 |
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Jiménez, Bruce, L,23640 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Rogers, Jeremy, G,19323 | 1584.76 | 0.00 | 0.00 | 782.99 | 801.77 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Yang, Jonathan,15523 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 |
| Hernandez, Raquel, W,13997 | 4586.35 | 0.00 | 0.00 | 2071.42 | 2514.93 |
| Adams, Amber,26746 | 2001.45 | 0.00 | 0.00 | 782.99 | 1218.46 |
| Shan, Jose,20843 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Navarro, Javier,14131 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| James, Mackenzie, L,27056 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Ward, Nicole, L,21272 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
| Zheng, Curtis, S,23645 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Ma, Ronnie, C,17815 | 3123.78 | 0.00 | 0.00 | 2443.35 | 680.43 |
| Garcia, Rebekah, M,14007 | 3772.41 | 0.00 | 0.00 | 3772.41 | 0.00 |
| Cook, Isaac, M,13994 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Gill, Roberto, W,14362 | 1845.90 | 0.00 | 0.00 | 1000.44 | 845.46 |
| Sai, Kristi, P,15665 | 2803.52 | 0.00 | 0.00 | 2181.56 | 621.96 |
| Lopez, Ann, T,15651 | 2746.55 | 0.00 | 0.00 | 2181.56 | 564.99 |
| Xu, Franklin, D,17103 | 6935.08 | 0.00 | 0.00 | 2181.56 | 4753.52 |
| Butler, Mya,13866 | 4639.51 | 0.00 | 0.00 | 2181.56 | 2457.95 |
| Harris, Ian, W,14128 | 3836.38 | 0.00 | 0.00 | 2071.42 | 1764.96 |
Generated 2025-12-21 22:54:55.550 UTC