[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raman, Phillip,21539 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Davis, Alexander, S,16747 | 2479.94 | 0.00 | 0.00 | 0.00 | 2479.94 |
| Carter, Gabrielle, B,16596 | 4486.54 | 0.00 | 0.00 | 2181.56 | 2304.98 |
| Stewart, Xavier,20645 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Raje, Arturo, C,14228 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Campbell, Luke,13722 | 3102.80 | 0.00 | 0.00 | 2443.35 | 659.45 |
| Sanz, Joe,12981 | 4809.81 | 0.00 | 2443.35 | 0.00 | 2366.46 |
| Jackson, Richard,20410 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Patterson, Zachary, R,13993 | 1804.92 | 0.00 | 1000.44 | 0.00 | 804.48 |
| Zhou, Karen,25309 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Torres, Melanie, L,19171 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Ruiz, Michele,16458 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Martinez, Tammy, R,20927 | 101.94 | 0.00 | 0.00 | 0.00 | 101.94 |
| Peterson, Stephanie, J,23136 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
Generated 2025-12-22 01:09:03.648 UTC