[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 61 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Thomas, Grace, L,17031 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Malhotra, Molly,24551 | 142.45 | 0.00 | 0.00 | 0.00 | 142.45 |
| Sanz, Byron,24799 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Alexander, Sydney,16760 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Jimenez, Max, C,13568 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Alonso, Clinton,23759 | 2475.95 | 0.00 | 0.00 | 2475.95 | 0.00 |
| Lopez, Julia, I,24638 | 57.09 | 0.00 | 0.00 | 0.00 | 57.09 |
| Baker, Isabella, A,14356 | 3352.40 | 0.00 | 0.00 | 1000.44 | 2351.96 |
| Kelly, Jessica,21261 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Murphy, Alyssa, O,25072 | 2469.05 | 0.00 | 0.00 | 0.00 | 2469.05 |
| Nath, Dustin,14637 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Washington, Jasmine,25151 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
Generated 2025-12-24 06:40:37.622 UTC