[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 77 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Huang, Laura, P,18185 | 3332.39 | 0.00 | 0.00 | 1000.44 | 2331.95 |
| Diaz, James, W,21790 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| He, Candice,13826 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Rodriguez, Sarah, K,21369 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Scott, Carlos,17830 | 2751.42 | 0.00 | 0.00 | 1000.44 | 1750.98 |
| Ross, Jennifer,28897 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Long, Carol, J,27044 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Gomez, Dwayne,12295 | 174.17 | 0.00 | 0.00 | 0.00 | 174.17 |
| Zhu, Jeffery, E,28489 | 786.33 | 0.00 | 0.00 | 0.00 | 786.33 |
| Chandra, Joe, G,15298 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Scott, Natalie, K,18764 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Bennett, Miranda,18819 | 2344.96 | 0.00 | 0.00 | 0.00 | 2344.96 |
| Foster, Taylor, F,18611 | 2391.94 | 0.00 | 0.00 | 0.00 | 2391.94 |
| Wood, Emily,11161 | 93.95 | 0.00 | 0.00 | 0.00 | 93.95 |
Generated 2025-12-23 16:59:39.037 UTC