[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 57 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| She, Jodi,22727 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Ramirez, Rachel, L,24742 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Cai, Clarence, L,22609 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Rai, Terry, A,26089 | 5798.04 | 0.00 | 3399.99 | 0.00 | 2398.05 |
| Edwards, Katelyn, L,14898 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Howard, Juan, K,18180 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Martin, Bruce, D,27936 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gonzalez, Kevin,27668 | 6006.56 | 3578.27 | 0.00 | 0.00 | 2428.29 |
| Foster, Caroline,14240 | 3391.39 | 0.00 | 0.00 | 1000.44 | 2390.95 |
| Moore, Joseph, L,25392 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Patterson, Victoria,16279 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Diaz, Arianna, C,14902 | 1538.58 | 0.00 | 699.10 | 0.00 | 839.48 |
Generated 2025-12-24 05:50:15.329 UTC